On Saturday 07 December 2002 00:56, Andre Dubuc wrote:
> I would like to update an int4 column with new values appended to the end
> (preferably with a delimiter such as @ or a comma).
>
> With PostgreSQl 7.2, I can't seem to add the number with a delimiter (it
> gives me a parser error at the delimiter). For example, If I update the
> field 'radd' that already has number 36 in it, it does append the new
> number, but without any space. So, if I updated with a new number, 6, the
> 'radd' result would now be '366' instead of '36 6'
>
> Without the delimiter, it might be difficult to do selects on this field
> when I need to find a specific number within the field. (Btw, I'm using
> $_SESSION['rid'] . . . etc instead of $rid in the actual code.) Any ideas
> what I'm doing wrong?
>
> Any suggestions will be greatly appreciated.
Am I missing something or are you really trying to insert non-digits into an
INTEGER field?
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
A compliment is something like a kiss through a veil.
-- Victor Hugo
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
