Re: [SQL] generic return for functions

> thing that causes me some minor grief is the fact that currently you > cannot have default values to function parameters, a feature we use a > lot. The default value is used when the parameter is NULL or unprovided? fn(integer, integer, integer default 32) select fn(integer, integer); <- Thi

Re: [SQL] Upgrade 7.2.3 -> 7.3 or more

On Tue, 2003-05-27 at 08:44, Benoît Bournon wrote: > I have to use PREPARE statement, I have just read an article that this > function is not implemented in 7.3 version ? It's implemented, however how it works internally will change somewhat in 7.4. http://www.postgresql.org/docs/view.php?versio

Re: [SQL] generic return for functions

Danny Su wrote: I am currently converting everything from SQL Server to PostgreSQL. This is for an application that is going to support Oracle, SQL Server and PostgreSQL at the same time. I have done a lot of the conversion already but I am stuck on functions that returns parts of views or tab

Re: [SQL] generic return for functions

I am afraid you are in exactly the same boat I am in. Coldfusion does not recognize the refcursor and as far as I know, currently the only way to return a result set that CF can read is to return a setof which requires you to return a user defined data type or a record. Another thing that cau

[SQL] generic return for functions

Hi, this is my first time using mailing list. Someone over at tek-tips suggested that I try here to see if someone can help me. I am currently converting everything from SQL Server to PostgreSQL. This is for an application that is going to support Oracle, SQL Server and PostgreSQL at the same

Re: [SQL] Index scan never executed?

Hi, This may make the query faster. try to split the query into two parts: first fetch all list-id's into a temp table (where cr.project_id = '55' and cr.start_time between '4/4/2003 0:0' and now()) then, join the temp table on lists (where l.list_of_lists_id = '691'). Morten -Opprinnel

[SQL] Upgrade 7.2.3 -> 7.3 or more

I have to use PREPARE statement, I have just read an article that this function is not implemented in 7.3 version ? is it correct or not ? If I must tu upgrade my server : I install different languages in databases, must I reinstall all of them after upgraded ? Ben --

Re: [SQL] tablename as attribute in pgplsql

Thx to Staphan Finally I find a solution : I have tables with different languages and I must find the correct languages : DECLARE  chaine VARCHAR := 'category';    col_return VARCHAR := 'id_category_unique' ;  col_id VARCHAR := 'id_category' ;  col_value INTEGER := 5 ;  lang_id INTEGER := 3

[SQL] How can I use a name of table in attribute of function, I try PREPARE...

I can do that on PostgreSQL 7.3 ?? Is it possible to do that ? or must I upgrade my server ?? PREPARE q1(text) FROM SELECT * FROM pg_tables WHERE tablename = $1 ; EXECUTE q1 USING 'client' ; DEALLOCATE q1 ; ---(end of broadcast)--- TIP 3: if po

[SQL] PostgreSQL and industry

Hello, I am searching for big industrial project using PostgreSQL as a database system manager. Can anyone give references or bibliograpghy other than the official postgres site? thank you and sorry for my english. DIB Walid Eleve Ingénieur en Technologies de l'information pour la santé Ecole

[SQL] Help required on update query

Hi Christoph,Could you please let me know the syntax for set newCol=oldCol, (This is reference to your mail pasted below)RegardsVikas Sawant[EMAIL PROTECTED]> > http://fts.postgresql.org/db/mw/msg.html?mid=1071582 > resp. > > You can rename your old column, create a new column varchar(100), upda

[SQL] postgresql and the industry

Hello, I am working on a bibliography or document concerning examples of use of PostgreSQL in the industrial circle. I visited the official site but there is not a lot of information. Thank you and good day. Walid DIB ---(end of broadcast)--- TIP