Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: issue with an assembled date field

  • From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: excalibur(at)accesswave(dot)ca
  • Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
  • Subject: Re: issue with an assembled date field
  • Date: Fri, 29 Feb 2008 14:33:58 -0500
  • Message-id: <11003.1204313638@sss.pgh.pa.us> <text/plain>
Chris Bowlby <excalibur(at)accesswave(dot)ca> writes:
> ERROR:  invalid input syntax for type date: "200W-01-01"

> the test data I am using for this example is as follows:

FWIW, I don't see any problem here using that test case.  Have you tried
looking directly at the output of the substring function, ie

select substring(ilch.lot_id::text, 5, 1) FROM my_lot_test ilch;

			regards, tom lane
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group