[SQL] Help with "missing FROM clause" needed

2006-03-06 Thread Thomas Beutin
Hi, to be compatible with the postgres standard syntax in 8.1.x i need some help for rewriting my "delete" statements ("select" is not a problem). I use the following statement: DELETE FROM partner_zu WHERE partner_zu.pa_id = partner.id AND partner_zu.m_id = '25' AND partner.open = 'm' AND pa

Re: [SQL] Help with "missing FROM clause" needed

2006-03-06 Thread Thomas Beutin
Richard Huxton wrote: Thomas Beutin wrote: Hi, to be compatible with the postgres standard syntax in 8.1.x i need some help for rewriting my "delete" statements ("select" is not a problem). I use the following statement: DELETE FROM partner_zu WHERE partner_zu.pa

Re: [SQL] UTF-8 Problem ?

2006-06-15 Thread Thomas Beutin
Hi Milen, Milen Kulev wrote: > Hi Listers, > I want to insert some german specific characters (umlaut characters) into a > table, but I am getting the following > Error message: > postgres=# EXECUTE stmt (1, 1 , 1 , 'GrĂ¼n') ; > ERROR: invalid UTF-8 byte sequence detected near byte 0xfc > >

Re: [SQL] UTF-8 Problem ?

2006-06-15 Thread Thomas Beutin
advice hepled me: [...] You're welcome :) Regards, -tb > -Original Message- > From: Thomas Beutin [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 15, 2006 2:45 PM > To: pgsql-sql@postgresql.org > Cc: Milen Kulev > Subject: Re: [SQL] UTF-8 Problem ? > >

Re: [SQL] join two tables with sharing some columns between two

2006-07-03 Thread Thomas Beutin
Hi, filippo wrote: > I have two tables like these: (this is an example, the actual tables > have diffferent fields and meanings) > > TABLE1 > id > person_name > date_arrival > date_departure > > TABLE2 > id > car_description > date_arrival > date_departure > > I'd like to make a query to have s