You're right !
LC_ALL=C explain the difference.
But I haven't found pg_controldata on my platform.
Is it installed with Postgresql 7.1 RPM for Redhat 7.0 ?
Thank's for your help
regards
- Original Message -
From: Tom Lane <[EMAIL PROTECTED]>
To: Michaël Fiey <
Hi,
I installed Postgresql 7.1 (RPMs for Redhat 7.0).
When I start psql with the command 'psql mydb', everything's ok
But whan I start psql with the command 'psql mybase@myhost' I receive :
psql: FATAL 1: Database "mybase@myhost" does not exist in system catalog
I used this syntax with Postgres
Hi,
Is it possible to count the number of rows returned by a command which use
the intersect operator,
such as :
SELECT col1 as my_col
FROM table
WHERE
INTERSECT
SELECT col1 as my_col
FROM table
WHERE
INTERSECT
SELECT col1 as my_col
FROM table
WHERE
Any help would be appreciated.
Regards
mi
I think so
what the exact impact of this variable ?
Thanks for your help
- Original Message -
From: Tom Lane <[EMAIL PROTECTED]>
To: Michaël Fiey <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2000 6:36 AM
Subject: Re: [GENERAL] PGBUFFERS
Hi,
I try to select data from a table with NULL value in, within a
C program.
I declare a cursor with ECPG ("exec sql declare mycursor
cursor for select mycolomn from mytable").
Each time I execute a fetch command, I got an error message
"NULL value without indicator".
I search in the archive
Hi,
I wrote a sql funtion which accept 1 varchar in and return an
int4.
I try to use this function in a C program with
ECPG.
The command : "exec sql select myfunction('myargument') into
:res" works fine
but :
"mycommand=select
myfonction('mychangingargument')
sql prepare myprep from mycomma
Hi,
I wonder what's the best between these 2 commands
:
First command :
SELECT * FROM TABLE1 WHERE COL1 like 'A%' AND COL2 LIKE
'B%' AND (COL3 LIKE 'C%' OR COL4 LIKE 'D%')
Second command :
SELECT * FROM TABLE1 WHERE COL1 like
'A%' AND COL2 LIKE 'B%' AND COL3 LIKE 'C%'
UNION
SELECT * FROM T
Does anyone know if it's possible to suppress the comment '
#line nn ...' which appear in the C file, after pre-processing with
ecpg.
Thanks