Re: Why does this work?

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why does this work?
Date: 2007-06-15 19:32:45
Message-ID: 1181935965.951553.93250@w5g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jun 15, 1:56 pm, harding(dot)(dot)(dot)(dot)(at)gmail(dot)com ("Ian Harding") wrote:
> I accidentally formatted a string for tsearch before trying to cast it
> to a date, and it worked!
>
> select 'June&15&2007'::date
> date
> ------------
> 2007-06-15
> (1 row)
>
> Is this a happy accident, or is it OK to count on it continuing to
> work this way?
>
> Thanks,
>
> Ian

select
'June&15&2007'::date
,'June.15.2007'::date
,'June__15__2007'::date

See: http://www.postgresql.org/docs/8.2/static/x71171.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2007-06-15 19:38:12 Re: is it possible to recover more than one recordset or cursor from a function?
Previous Message guillermo arias 2007-06-15 19:09:07 is it possible to recover more than one recordset or cursor from a function?