use to carry out the SQL:
UPDATE _table
SET _bbb = to_number(substring(_aaa from 1 for 5), '9')
WHERE _aaa <> ' ';
I guess a function checking if a string contains only numbers would be
betteroff. But I find no such functions. Checking that it's not blank
would be the only solution I can think of.
Thanks again.
regards,
Daniel Lau
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Hi all,
Thank you for reading this mail.
I am trying to do the following:
Extract the first half of _aaa and put it in column _bbb
Here is the table, named: _table:
Varchar[10] | Double Precision
_aaa_bbb
_
1234567890
I used two function
in advance.
regards,
Daniel Lau
On Mon, 22 Dec 2003, Michael Fuhr wrote:
> On Mon, Dec 22, 2003 at 04:54:01PM +0800, Daniel Lau wrote:
> > I am wondering if we are able to extract the x-coordinate from a
> > point-type attribute with SQL. I have been looking for this sort of
>
Hi all,
I am wondering if we are able to extract the x-coordinate from a
point-type attribute with SQL. I have been looking for this sort of
functions from documents and websites but it seems the function does not
exist. Or, any altnernate to do so?
regards,
Daniel Lau
Hong Kong University of
