pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
is there a special function like the format on raise notice
2+ messages / 2 participants
[nested] [flat]

* is there a special function like the format on raise notice
@ 2003-04-23 08:52  jack <datactrl@tpg.com.au>
  0 siblings, 1 reply; 2+ messages in thread

From: jack @ 2003-04-23 08:52 UTC (permalink / raw)
  To: pgsql-sql

Hi, all

With pl/sql, is there a special function such as

s1 := function(''invalid code: %'',iErrCode);

s1 becomes ''invalid code: 120''

Thank you

Jack




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: is there a special function like the format on raise notice
@ 2003-04-23 09:16  Tomasz Myrta <jasiek@klaster.net>
  parent: jack <datactrl@tpg.com.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Tomasz Myrta @ 2003-04-23 09:16 UTC (permalink / raw)
  To: jack <datactrl@tpg.com.au>; +Cc: pgsql-sql

Uz.ytkownik jack napisa?:
> Hi, all
> 
> With pl/sql, is there a special function such as
> 
> s1 := function(''invalid code: %'',iErrCode);
> 
> s1 becomes ''invalid code: 120''
> 
> Thank you
s1:=''invalid code: '' || iErrCode;

Tomasz




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-04-23 09:16 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-23 08:52 is there a special function like the format on raise notice jack <datactrl@tpg.com.au>
2003-04-23 09:16 ` Tomasz Myrta <jasiek@klaster.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox