Hi Jason,

So, I gather from your reply that I cannot add more digits to that integer 
field separated by spaces or whatever?  I sort of figured I won't be able to 
do it, so I'm trying to get things working by changing the type to varchar() 
and doing it as a string. Seems to work - with glitches.


On Friday 06 December 2002 01:39 pm, you wrote:
> 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?

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to