Re: [GENERAL] to pass a parameter

2000-06-09 Thread NRonayette
and the Pg module for exemple ? Nicolas. NRonayette wrote: > (i copy/paste) > Parameters > > A parameter is used to indicate a parameter in a SQL function. Typically > this is used in SQL function definition statement. The > form of a parameter is: > > $number >

[GENERAL] A Query on PG_ tables

2000-06-19 Thread NRonayette
Hi everybody, I'm using Postgresql 7.0. I want to find, by a query on the postgres table (like pg_class, pg_attribute, pg_trigger, etc), the name of all the colonnes that are foreign key on my base. Pg_trigger gives me some information about the foreigns key i added on my tables (n

Re: [GENERAL] Why isn't that null

2000-06-27 Thread NRonayette
Hi, May be this insert will work with your test in your function insert into aufpos(auftrag, artikel, best_menge, vkp, lieferwoche, cuser, ctime, uuser, utime) values ('175','8501900','12',NULL,'3500','matthias', now (), 'matthias',now ()) Nicolas Matthias Teege a écrit : > > Moin, > > I h