Hi Adrian,
I have number of similar tables that have different number of fields (similar
in functionality). An in my stored procedure am trying to select a row from one
of these tables (that i don't know in advance, hence the use of record) and
return the data in the form of a table that has c
Adrian Klaver <[EMAIL PROTECTED]> writes:
> On Thursday 23 November 2006 08:45 pm, Tom Lane wrote:
>> This should work --- in PG 8.1 or later.
> The documentation for pl/pgsql in 8.1 and higher says different.
> http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STAT
On Thursday 23 November 2006 10:54 pm, Mulham freshcode wrote:
> Hi Tom,
>
> Thanks for the help. Am using version 8.0 and it seems like RECORD is not
> that dynamic still. I tried with the FOR ... IN EXECUTE ... LOOP and it
> does the trick. But am still finding it hard to move forward with this.
On Friday 24 November 2006 06:55 am, Andreas Kretschmer wrote:
> Adrian Klaver <[EMAIL PROTECTED]> schrieb:
> > On Thursday 23 November 2006 08:45 pm, Tom Lane wrote:
> > > Mulham freshcode <[EMAIL PROTECTED]> writes:
> > > > execute sql_str1 into svc_data_rec ;
> > > >
> > > > svc_data_rec is a RE
Adrian Klaver <[EMAIL PROTECTED]> schrieb:
> On Thursday 23 November 2006 08:45 pm, Tom Lane wrote:
> > Mulham freshcode <[EMAIL PROTECTED]> writes:
> > > execute sql_str1 into svc_data_rec ;
> > >
> > > svc_data_rec is a RECORD, which is supposed to be dynamic.
> >
> > This should work --- in PG
On Thursday 23 November 2006 08:45 pm, Tom Lane wrote:
> Mulham freshcode <[EMAIL PROTECTED]> writes:
> > execute sql_str1 into svc_data_rec ;
> >
> > svc_data_rec is a RECORD, which is supposed to be dynamic.
>
> This should work --- in PG 8.1 or later. In older versions you'd have
> to fool arou
Hi lists,
I need to create some jobs on my database but I can't find out the
pgagent (executable). Can someone help me in this challenger ?
I am using :
PostgreSQL 8.1.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
3.4.4 20050721 (Red Hat 3.4.4-2)
Regards ...
--
=-=-=-=-=-=-=-=-=-=-=-=
On Fri, 2006-11-24 at 11:07 -0200, Ezequias Rodrigues da Rocha wrote:
> Does anybody have numbers of PostgreSQL in action ?
>
> Numbers like the biggest insert in mileseconds, the larger database etc ?
First, you may want to post this in the GENERAL or in the PERFORMANCE
lists since this isn't re
Στις Παρασκευή 24 Νοέμβριος 2006 15:07, ο/η Ezequias Rodrigues da Rocha
έγραψε:
> Hi list,
>
> Does anybody have numbers of PostgreSQL in action ?
>
> Numbers like the biggest insert in mileseconds,
what do you mean here?
LOCK TABLE in ACCESS EXCLUSIVE MODE;
and the insert will take forever.
>
Hi list,
Does anybody have numbers of PostgreSQL in action ?
Numbers like the biggest insert in mileseconds, the larger database etc ?
Regards...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
10 matches
Mail list logo