I hereby claim:
- I am pedersenthomas on github.
- I am pedersenthomas (https://keybase.io/pedersenthomas) on keybase.
- I have a public key ASBbkPsBWbFVoosZi9fQshdUkqiXHB3y__jZ2VEiVN7Ibwo
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
import 'dart:async'; | |
import 'package:postgresql/postgresql.dart'; | |
void main() { | |
var username = "TheRightMan"; | |
var password = "WithTheRightSecret"; | |
var DBname = "AtTheRightPlace"; | |
var uri = 'postgres://$username:$password@localhost:5432/$DBname'; | |
CREATE OR REPLACE FUNCTION | |
InsertPerson(text, text, timestamp, double precision) | |
RETURNS | |
INTEGER | |
AS | |
$delimiter$ | |
INSERT INTO person(firstname, lastname, dateofbirth, height) VALUES | |
($1, $2, $3, $4) | |
RETURNING id | |
$delimiter$ |
import 'dart:async'; | |
import 'package:postgresql/postgresql.dart'; | |
void main() { | |
var username = "TheRightMan"; | |
var password = "WithTheRightSecret"; | |
var DBname = "AtTheRightPlace"; | |
var uri = 'postgres://$username:$password@localhost:5432/$DBname'; | |
INSERT INTO person | |
(firstname, lastname, dateofbirth, height) | |
VALUES | |
('John', 'Doe', TIMESTAMP '1980-05-17', 1.92), | |
('Jane', 'Doe', TIMESTAMP '1983-10-23', 1.87), | |
('Baby', 'Doe', TIMESTAMP '2013-09-21', 0.43); |
CREATE TABLE person( | |
id SERIAL PRIMARY KEY, | |
firstname varchar(80), | |
lastname varchar(80), | |
dateofbirth timestamp, | |
height double precision | |
) |