On Tue, 2004-09-07 at 06:44, Theo Galanakis wrote:
> How could you determine if a value being inserted into a varchar
> column is numeric?
>
> I was thinking of using a Regular expression to find this, something
> like
>
> .. Where content ~* '^[0-9]{1,10}'
~ '^[0-9]+$'
Your version only check
Title: Isnumeric function?
How could you determine if a value being inserted into a varchar column is numeric?
I was thinking of using a Regular _expression_ to find this, something like
.. Where content ~* '^[0-9]{1,10}'
There must be an easier way like a isNumeric() function?
Theo
Hello,
Is there a way (i.e. a query in pg_catalog) to determine when a table was
last ANALYZEd, if at all?
--
Greetings from Troels Arvin, Copenhagen, Denmark
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTEC
Hi to
all,
I have a database, where in the tables I have
around 100 constrains (link to other tables) that don't have a name
"" or they have a name like "$1" "$2". Now, I have a module which
bases on the same structure, but I get some query errors from a
"" constraint. I really don't know
On Sun, 05 Sep 2004 19:51:44 +0200, Pierre-Frédéric Caillaud
<[EMAIL PROTECTED]> wrote:
>> But after looking closely at the list of a possible properties, i found
>> out that some of them depend on others. For example, if item is a
>> PDF document, it can have an index. But a document can also ha
