Re: [SQL] Special characters in SQL queries

2003-03-12 Thread Richard Huxton
On Wednesday 12 Mar 2003 3:28 am, Vernon Wu wrote: > Thank Christoph for your information. > > I don't program in C at all, but Java. Although I can make a way to call > the C library function from Java, it isn't suitable solution, I believe. > > I only desire to find out all the type of characters

[SQL] The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard

2003-03-12 Thread David Delorme
I am trying to integrate MapInfo with a postgresql backend. Problem: MapInfo query uses both quoted and unquoted statements i.e. "MAPINFO"."MAPINFO_MAPCATALOG" and mapinfo.mapinfo_mapcatalog I can not change the query statements that MapInfo uses to talk to the odbc driver. I am in

Re: [SQL] LEFT JOIN and missing values

2003-03-12 Thread mila
Tomasz, > select c.id1, d.id1, sum( > case when c.id2 is null then 0.5 else c.val2 end * > case when d.id2 is null then 0.5 else d.val2 end *T1.val1) > from > T1 > left join T2 c on (c.ID2 = T1.id) > left join T2 d on (d.id2 = T1.id and (c.id1 < d.id1 or c.id1 is null)) > group by c.id1,

Re: [SQL] [HACKERS] Cursors and backwards scans and SCROLL

2003-03-12 Thread Zeugswetter Andreas SB SD
>> 2. Error out only if a backwards fetch is actually attempted on a plan >> tree that can't handle it (which could only happen if SCROLL wasn't >> given). This is efficient and flexible, but it exposes implementation >> details to the user, in that whether an error occurs will depend on >> which

Re: [SQL] [HACKERS] Cursors and backwards scans and SCROLL

2003-03-12 Thread Jeroen T. Vermeulen
On Sun, Mar 09, 2003 at 03:35:11PM -0500, Tom Lane wrote: > > 2. Error out only if a backwards fetch is actually attempted on a plan > tree that can't handle it (which could only happen if SCROLL wasn't > given). This is efficient and flexible, but it exposes implementation > details to the user,