Re: [SQL] bug in information_schema?

2005-08-01 Thread Peter Eisentraut
Am Samstag, 30. Juli 2005 17:15 schrieb Tom Lane: The unconstrained join against pg_user is clearly unnecessary, and in fact I took it out a few days ago. I'm not sure whether the SELECT DISTINCT is still needed --- it might be, if there can be multiple pg_depend entries linking the same

Re: [SQL] How to connect ORACLE database from Postgres function using plpgsql/pltclu?

2005-08-01 Thread Dawid Kuroczko
On 8/1/05, Dinesh Pandey [EMAIL PROTECTED] wrote: Is there any way to connect ORACLE database from Postgres function using plpgsql/pltclu? With PLpgSQL I don't think its possible. I don't know how about PLtclU (should be possible), but I'm sure its doable from PLperlU (using DBI). Don't

Re: [SQL] How to connect ORACLE database from Postgres function

2005-08-01 Thread Sean Davis
Title: Re: [SQL] How to connect ORACLE database from Postgres function using plpgsql/pltclu? On 8/1/05 6:35 AM, Dawid Kuroczko [EMAIL PROTECTED] wrote: On 8/1/05, Dinesh Pandey [EMAIL PROTECTED] wrote: Is there any way to connect ORACLE database from Postgres function using plpgsql/pltclu?

Re: [SQL] How to connect ORACLE database from Postgres functionusing plpgsql/pltclu?

2005-08-01 Thread Dinesh Pandey
Title: Re: [SQL] How to connect ORACLE database from Postgres function using plpgsql/pltclu? Thanks Sean, It great help from you. Thanks Dinesh Pandey From: Sean Davis [mailto:[EMAIL PROTECTED] Sent: Monday, August 01, 2005 4:47 PM To: [EMAIL PROTECTED] Cc: PostgreSQL Subject:

[SQL] Calling SQL functions that return sets

2005-08-01 Thread Chris Mungall
Hi all, I have a question on functions returning sets. I have a lot of complex functionality I would like to keep in the DBMS rather than in an application, and I would like this functionality to be available as queries over standard SQL relations. Section 31.4.4 of the docs

Re: [SQL] Calling SQL functions that return sets

2005-08-01 Thread Tom Lane
Chris Mungall [EMAIL PROTECTED] writes: What are the reasons for deprecating the use of the function in the SELECT clause? The semantics of having more than one set-returning function in the target list are, um, poorly thought out. However, we haven't removed the feature because (as you note)

Re: [SQL] Calling SQL functions that return sets

2005-08-01 Thread Chris Mungall
On Mon, 1 Aug 2005, Tom Lane wrote: Chris Mungall [EMAIL PROTECTED] writes: What are the reasons for deprecating the use of the function in the SELECT clause? The semantics of having more than one set-returning function in the target list are, um, poorly thought out. However, we haven't

Re: [SQL] Calling SQL functions that return sets

2005-08-01 Thread Tom Lane
Chris Mungall [EMAIL PROTECTED] writes: On Mon, 1 Aug 2005, Tom Lane wrote: Chris Mungall [EMAIL PROTECTED] writes: What are the reasons for deprecating the use of the function in the SELECT clause? The semantics of having more than one set-returning function in the target list are, um,