Re: Pl Pgsql problem

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: lihao <lihao(at)sageway(dot)com(dot)sg>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Pl Pgsql problem
Date: 2003-04-28 09:20:11
Message-ID: 3EACF24B.5050502@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dnia 2003-04-28 11:29, Uz.ytkownik lihao napisa?:

> So the Line 9 is this line:
> select (''UPD'' || int2hex(nextval(''updid''), 8)) as
> v_updid;
Did you mean:

select into v_updid ''UPD'' || int2hex(nextval(''updid''), 8);
?

Tomasz

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message lihao 2003-04-28 09:29:14 Re: Pl Pgsql problem
Previous Message lihao 2003-04-28 09:15:16 Pl Pgsql problem