Re: [GENERAL] Case sensitive order by

2001-05-09 Thread Michaël Fiey
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 <

[GENERAL] Database Connect

2001-04-20 Thread 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

[GENERAL] Count and Intersect

2001-03-01 Thread Michaël Fiey
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

Re: [GENERAL] PGBUFFERS

2000-11-08 Thread Michaël Fiey
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

[GENERAL] NULL value withe cursor

2000-09-04 Thread Michaël Fiey
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

[GENERAL] ECPG and SQL function

2000-08-24 Thread Michaël Fiey
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

[GENERAL] Is union better than or

2000-08-03 Thread Michaël Fiey
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

[GENERAL] Comment #line after pre-processing

2000-07-25 Thread Michaël Fiey
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