[SQL] vararg plpsql function

Hi, Is it possible to create vararg (like in C) functions in language plpgsql somehow? Daniel ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTE

[SQL] undigested email

Hello, According to my profile, I am subscribed for daily ~digest~. Yet, I recieve multiple ~individual~ emails every day. Am I doing something wrong? TJ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [SQL] plpsql function problem

[EMAIL PROTECTED] writes: > function >. >insert into table1 ... --> trigger function (runs after insert) > . > insert into table2 ... >. >select from table2 ... not found >. > This info looks to be unavailable

[SQL] plpsql function problem

Hi, I'm writing a plpgsql function. There is an insert in it (let's say to table1). This insert causes to call a trigger function which inserts some info to an other table (let's say table2): function . insert into table1 ... --> trigger function (runs after insert)

Re: [SQL] Calling a table residing in another database from Plpgsql

[EMAIL PROTECTED] wrote: SELECT * from dblink('host=192.168.0.50 dbname=AK1 user=akteam','Select userid from user_reg') as t (userid integer); I am getting an error as "ERROR: function dblink("unknown", "unknown") does not exist" Have you installed the dblink functions into your database? See REA

Re: [SQL] Calling a table residing in another database from Plpgsql

am Tue, dem 04.01.2005, um 21:13:46 -0800 mailte [EMAIL PROTECTED] folgendes: > Hi, > > I have function called test1() in database 1. I need to input the value > from this function into another table which is in database2. > > How can i achieve this task in plpgsql. I went through some documenta

Re: [SQL] [JDBC] Calling a table in another database from plpgsql

On Wed, 5 Jan 2005, Dave Cramer wrote: > Kris is correct, this is a jdbc list, however to satisfy your curiosity, > you can't access data from another database. > You certainly can with dblink which is what his question was about. I didn't answer him because I remembered a recent off-topic q

Re: [SQL] foreign key problems

On Wed, 5 Jan 2005, Stephan Szabo wrote: > > On Wed, 5 Jan 2005, [iso-8859-2] BARTKO, Zoltán wrote: > > > Ok, so I made some changes (manual "inheritance" of PK and FK > > constraints), but nevertheless I get still the same dumb error. I made > > a dump of the DB via pg_dump, it is available at >

Re: [SQL] foreign key problems

On Wed, 5 Jan 2005, [iso-8859-2] BARTKO, Zoltán wrote: > Ok, so I made some changes (manual "inheritance" of PK and FK > constraints), but nevertheless I get still the same dumb error. I made > a dump of the DB via pg_dump, it is available at > > http://de.geocities.com/bartkozo/dump.tgz > > DRec

Re: [SQL] foreign key problems

Ok, so I made some changes (manual "inheritance" of PK and FK constraints), but nevertheless I get still the same dumb error. I made a dump of the DB via pg_dump, it is available at http://de.geocities.com/bartkozo/dump.tgz DRecord was dropped, the columns moved into DObject. I still have no ide