hello all,
i want to make dynamic sql query like this
select * from tb_cust where name='erick' and age='20'
to
select * from tb_cust $1
i have tried but error comeup
any suggestion?
thanks
Ricky
--
Gutten Aben Sugeng Sonten, Jangane K
32 PM, Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
> am 06.04.2005, um 13:55:35 +0700 mailte bandeng folgendes:
> > hello guys,
> >
> > I want to use crosstab function but that function it doesnt exist. my
> > version is 7.3 so how do i get the tablefunc.sql from
hello guys,
I want to use crosstab function but that function it doesnt exist. my
version is 7.3 so how do i get the tablefunc.sql from postgre contrib?
i saw in ver 8 win32 is checkable.
Thanks
Ricky
--
Gutten Aben Sugeng Sonten, Jangane Kurang Santen
bandeng
ct procsrc from pg-catalog.pg_proc where proname=... and
> MN> pronamespace=...;
> xxx:=select procsrc from pg_catalog.pg_proc where proname=... and
> pronamespace=...;
>
> --
> Regards,
> Mihail Nasedkin mailto:[EMAIL PROTECTED]
>
>
--
Gutt
hello guys,
I need help. I have functions but it is saved to pg_toast, when I
dump the database, the function from pg_toast is not copied. so is
there any sql or syntax to view function data ?
Thanks
Ricky
---(end of broadcast)---
TIP 9: the plan
i := i + 1;
end loop;
raise info i;
On Sun, 6 Mar 2005 12:10:55 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sun, Mar 06, 2005 at 11:54:15PM +0700, bandeng wrote:
>
> > I need some help, I have created function with argument in array.
> > I already try to
Aben Sugeng Sonten, Jangane Kurang Santen
bandeng
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
hello guys,
I need some help, I have created function with argument in array.
I already try to find array function in manual but failed.
so is there any solution to counting array value and looping array value?
some language usually use count($array)
Thank in a bunch
Ricky
---
