if join database1 database2
how to make
I use VB or DELPHI
thanks
Hello,
in the C interface documentation there is an example using:
res = PQexec(conn, "DECLARE mycursor CURSOR FOR select * from
pg_database");
if (!res || PQresultStatus(res) != PGRES_COMMAND_OK)
{
fprintf(stderr, "DECLARE CURSOR command failed\n");
PQclear(res);
Hi all,
I am using following query to create new type 'lo'
create type lo
(internallength=4,externallength=10,input=int4in,output=int4out,
default='',passedbyvalue);
i am trying to insert the image by following query:
insert into table (user_id,image) values
Tom Lane wrote:
"K. Ari Krupnikov" [EMAIL PROTECTED] writes:
CREATE FUNCTION foo (INT)
RETURNS SETOF INT AS '
SELECT id
FROM table
WHERE some_colunm $1
ORDER BY some_other_colunm
' LANGUAGE 'sql';
ERROR: function declared to return int4 returns multiple
Volker Paul [EMAIL PROTECTED] writes:
Is someone maintaining the C++ interface and its documentation?
Not really. Feel free to step up and lend a hand ...
regards, tom lane
Cursors and standard queries are pretty much the same, except the cursor
can control the rows returned.
Hello,
in the C interface documentation there is an example using:
res = PQexec(conn, "DECLARE mycursor CURSOR FOR select * from
pg_database");
if (!res || PQresultStatus(res)
I have a tab delimited file that I'm trying to import
into an empty table.
I've set the table up as follows:
create table member (
member_id serial not null,
fname varchar(25) not null,
lname varchar(25) not null,
member_since date not null,
Primary Key (member_id)
);
My member.txt file looks
Jeff S. writes:
create table member (
member_id serial not null,
fname varchar(25) not null,
lname varchar(25) not null,
member_since date not null,
Primary Key (member_id)
);
My member.txt file looks like this:
Joe Smith 2000/01/14
Frank Jones 2000/06/21
Mike Davis
hi there,
with two tables i want to make some constraint-restrictions
create table address ( id serial, country_id int4, );
and
create table country (id serial, ...);
to make sure that now country-row is deleted if there is still a country_id
in address table.
e.g.
address: 1, 2, ...