Isnumeric function?

Поиск
Список
Период
Сортировка
От Theo Galanakis
Тема Isnumeric function?
Дата
Msg-id 82E30406384FFB44AFD1012BAB230B55037D056E@shiva.au.lpint.net
обсуждение исходный текст
Ответы Re: Isnumeric function?
Список pgsql-sql
<p><font size="2">How could you determine if a value being inserted into a varchar column is numeric?</font><p><font
size="2">Iwas thinking of using a Regular expression to find this, something like</font><p><font size="2">.. Where
content~* '^[0-9]{1,10}'</font><p><font size="2">There must be an easier way like a isNumeric()
function?</font><p><fontsize="2">Theo</font><table><tr><td bgcolor="#ffffff"><font
color="#000000">______________________________________________________________________<br/>This email, including
attachments,is intended only for the addressee<br />and may be confidential, privileged and subject to copyright. If
you<br/>have received this email in error, please advise the sender and delete<br />it. If you are not the intended
recipientof this email, you must not<br />use, copy or disclose its content to anyone. You must not copy or <br
/>communicateto others content that is confidential or subject to <br />copyright, unless you have the consent of the
contentowner.<br /></font></td></tr></table> 

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

Предыдущее
От: Troels Arvin
Дата:
Сообщение: When a table was last ANALYZEd
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: Isnumeric function?