Re: [SQL] output

2003-10-06 Thread Popeanga Marian
Popeanga Marian wrote:       I am using libpg inside a plugin. For oracle conections i can read the server output with this package dbms_output.read_line (... ).    For pgsql is something similar for reading server output ?   Tom Lane wrote: Popeanga Marian <[EM

Re: [SQL] output

2003-10-02 Thread Popeanga Marian
      I am using libpg inside a plugin. For oracle conections i can read the server output with this package dbms_output.read_line (... ).    For pgsql is something similar for reading server output ?   Tom Lane wrote: Popeanga Marian <[EMAIL PROTECTED]> writes: Now if i don't us

Re: [SQL] output

2003-10-02 Thread Tom Lane
Popeanga Marian <[EMAIL PROTECTED]> writes: > Now if i don't use psql from where i can read the output ? If you're using libpq directly, you can install a notice processor hook routine to catch NOTICE messages. Otherwise they go to stderr. regards, tom lane -

Re: [SQL] output

2003-10-02 Thread Richard Huxton
On Thursday 02 October 2003 12:09, Popeanga Marian wrote: > > Inside a plpgsql block . > RAISE NOTICE ''Operation performed!''; > > Now if i don't use psql from where i can read the output ? Ah - I think you need to set CLIENT_MIN_MESSAGES accordingly and then you can check for a non-fatal

Re: [SQL] output

2003-10-02 Thread Popeanga Marian
Richard Huxton wrote: On Thursday 02 October 2003 09:52, Popeanga Marian wrote: Hello all, I am interested on how can i put output data for debugging purposes. Any sample will be very good! Output what data when? To what? If you can describe your situa

Re: [SQL] output

2003-10-02 Thread Richard Huxton
On Thursday 02 October 2003 09:52, Popeanga Marian wrote: > Hello all, > > > I am interested on how can i put output data for debugging > purposes. Any sample will be very good! Output what data when? To what? If you can describe your situation, I'm sure we can come up with somethin

Re: [SQL] Output of function into a file

2002-11-12 Thread Rajesh Kumar Mallah.
in 7.3 you will be able to return multiple rows with multiple columns. 7.3 stable is going to be out soon as it in beta 5 stage currently. regds mallah. On Saturday 09 November 2002 11:00, karthick v wrote: > Hi, > > I am writing a small function to manipulate records in multiple > tables. Si

Re: [SQL] Output of function into a file

2002-11-12 Thread Christoph Haller
> > I am writing a small function to manipulate records in multiple > tables. Since the function cannot return more than one value, I would > like to get all the outputs of the queries and append them into a text > file. > > Is there any way to do it inside the function. I came across many > pos