Re: [SQL] Date Validation?

2001-07-14 Thread Christopher Sawtell
On Sun, 15 Jul 2001 06:40, Josh Berkus wrote: > Richard, > > > Poked around and had a think and can't come up with anything better > > than > > Stephan Szabo's suggestion of hacking PG's built-in function. You'll > > want > > to_timestamp() which is called from to_date and it's in > > src/backend/

Re: [SQL] Date Validation?

2001-07-14 Thread Josh Berkus
Richard, > Poked around and had a think and can't come up with anything better > than > Stephan Szabo's suggestion of hacking PG's built-in function. You'll > want > to_timestamp() which is called from to_date and it's in > src/backend/utils/adt/formatting.c - AFAICT you'll just need to > comment

Re: [SQL] Date Validation?

2001-07-14 Thread dev
> Richard, > >> Out of curiosity Josh, why aren't you validating in PHP? - only takes >> a >> couple of lines there. > > We are. It's just that all other validation takes place inside the > PL/pgSQL functions in order to keep all the business logic in the > database. Having one form of validat