Re: Date Validation?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Date Validation?
Дата
Msg-id 006401c10bbd$effc5320$1001a8c0@archonet.com
обсуждение исходный текст
Ответ на Date Validation?  ("Josh Berkus" <josh@agliodbs.com>)
Ответы Re: Date Validation?  ("Josh Berkus" <josh@agliodbs.com>)
Список pgsql-sql
From: "Josh Berkus" <josh@agliodbs.com>

> Folks,
>
> Pardon me for asking this again, but I received *no* responses last
> week.
>
> Question:  Is there any function or method which will allow me, in SQL
> or PL/pgSQL, to validate dates without raising an error for invalid
> dates?
>
> Expansion:  I have a number of PL/pgSQL functions which must accept
> dates as parameters from the PHP4 interface.  There is, however, the
> possibility that an invalid date will be passed, such as "2001-02-31"
> due to the nature of HTML forms date selector.

Out of curiosity Josh, why aren't you validating in PHP? - only takes a
couple of lines there.

- Richard Huxton



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Ari Nepon"
Дата:
Сообщение: You have an error in your SQL syntax near '' at line 1
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: Date Validation?