Re: More outdated examples - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: More outdated examples
Date
Msg-id 200303171938.h2HJcR317134@candle.pha.pa.us
Whole thread Raw
In response to More outdated examples  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: More outdated examples  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I can find no suitable replacement for this example.  Can anyone else?

---------------------------------------------------------------------------

Peter Eisentraut wrote:
> This example in User's Guide section 7.2 doesn't work anymore at all:
> 
> tgl=> select @ text '-4.5' as "abs";
>  abs
> -----
>  4.5
> (1 row)
> 
> What really happens is this:
> 
> => select @ text '-4.5' as "abs";
> ERROR:  Unable to identify a prefix operator '@' for type 'text'
>         You may need to add parentheses or an explicit cast
> 
> Again, delete or new example?
> 
> -- 
> Peter Eisentraut   peter_e@gmx.net
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: request for sql3 compliance for the update command
Next
From: Bruce Momjian
Date:
Subject: Re: Possibly inconsistent type casting logic