Pavel Stehule wrote: > 2009/4/10 <bfb21@xxxxxxxxxxx>: > > Yes, I mentioned that I could use the to_date function, but as I said, that > > would involve a LOT of changes to a LOT of source code, which I'm trying to > > avoid. > > > > other solution is custom datatype. It isn't too much work, but it is > coding in C. Yep, that was my first idea too. You would copy an existing data type, and modify just the _input_ routine to handle input with no delimiters. I would simply add the delimiters and pass the string to the original input function; it really isn't that much work. The only downside is that you have to create/use a custom data type for this. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general