Stephane Bortzmeyer wrote:
>
> On Thursday 6 July 2000, at 18 h 5, the keyboard of "Andrew Snow"
> <als(at)fl(dot)net(dot)au> wrote:
>
> > SELECT event FROM events WHERE to_char(CURRENT_TIMESTAMP, 'ww') =
> > to_char(eventdate, 'ww');
>
> Sorry, I should have mentioned that I played with to_char and it seems the documentation is wrong:
>
> conferences=> select * from conferences where to_char(CURRENT_TIMESTAMP, 'ww') =
> conferences-> to_char(date_begin, 'ww');
> ERROR: No such function 'to_char' with the specified attributes
>
> Or it is a new feature of PostgreSQL 7?
to_xxx are new to 7.0, thanks to Karel Zak.
Mike Mascari