Re: [SQL] SERIAL type does not generate new ID ?

2000-07-12 Thread Jean-Marc Libs
On Sat, 10 Jun 2000, Jean-Marc Libs wrote: Hi all, > I don't really understand what happens, so I put context, then problem: > > 1/ Context > -- > I have this table: > > CREATE TABLE film ( > film_id SERIAL PRIMARY KEY, snip > ) > ; > SELECT

[SQL] SERIAL type does not generate new ID ?

2000-07-10 Thread Jean-Marc Libs
(film_id)+1,'$film_country_id','$film_country_id2','$film_country_id3','$film_country_id4','$film_prod_year','$film_ec_certif','$film_ce_certif','$film_eur_support','$film_media_support','$film_provisoire')"

Re: Antw: [SQL] Problem with joins

2000-07-05 Thread Jean-Marc Libs
On Wed, 5 Jul 2000, Gerhard Dieringer wrote: > Jean-Marc Libs wrote: > >... > >I have also tried: > >select source_name,data_value from source,data where data_source_id=source_id union >select source_name,source_id,NULL from source,data > > >This is a bit bet

[SQL] Problem with joins

2000-07-05 Thread Jean-Marc Libs
gant way of doing it: a solution or pointers to relevant online litterature would be welcome. Thanks, Jean-Marc Libs -- Jean-Marc Libs, ingénieur INTERNET/INTRANET Actimage 1 rue St Leon F-67000 STRASBOURGhttp://www.actimage.net Professionnel : [EMAIL PROTECTED] Lieu de travail : [EMAIL PROTECTED]