[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] insert statment
From: Gregoire Thomas <gregoire () starlab ! net>
Date: 1999-08-30 9:56:01
[Download RAW message or body]
Have you tried
Insert into product values('p001' , 'ASS\'Y' , 'o');
Greg
> Hello all!
>
> I have a insert statement and I found problem with it!
>
> The statement is:
> Insert into product values('p001' , 'ASS'Y' , 'o')
> The second field of the table is ASS'Y so the compiler found it is
> error!
> I can not change the data but wnat to change the quota ' to ~.
>
> so the insert statement should be :
> insert into product values(~p001~ , ~ASS'Y~ , ~o~ )
>
> I can not find the seting function for this environment change!
>
> How can I change it???
> Thank You in advance!
>
> sharon
>
>
>
> Sharon Chow
> ???
> Regaltronic
> MIS
> <sharon@
[Attachment #3 (text/html)]
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<b>Have you tried</b>
<br><b>Insert into product values('p001' , 'ASS\'Y'
, 'o');</b>
<br><b>Greg</b>
<blockquote TYPE=CITE>Hello all!
<p>I have a insert statement and I found problem with it!
<p>The statement is:
<br><b>Insert into product values('p001' , 'ASS'Y'
, 'o')</b>
<br>The second field of the table is ASS'Y so the compiler found it is
error!
<br>I can not change the data but wnat to change the quota '
to ~.
<p>so the insert statement should be :
<br>insert into product values(~p001~ , ~ASS'Y~
, ~o~ )
<p>I can not find the seting function for this environment change!
<p>How can I change it???
<br>Thank You in advance!
<p>sharon
<br>
<br>
<p> Sharon Chow
<br> ???
<br> Regaltronic
<br> MIS
<br>
<sharon@</blockquote>
</html>
************
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic