pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
A question
3+ messages / 3 participants
[nested] [flat]

* A question
@ 2000-02-02 14:23 Julie <j.baratchart@estia.fr>
  0 siblings, 0 replies; 3+ messages in thread

From: Julie @ 2000-02-02 14:23 UTC (permalink / raw)
  To: pgsql-sql

Hello,
Help me (?!?!)
I have a problem :
if I want to write a request like INSERT INTO table
VALUES('variable1','variable2');
if my variable is " j'aime sql "
the request is refused because of the " ' "
A symbol exist ??? a / or \ before? after? or...

I need help

thanks

Julie







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* A Question
@ 2000-05-26 10:53 Sherril Mathew <m_sherril@hotmail.com>
  2000-05-26 12:48 ` Re: A Question Peter Eisentraut <e99re41@DoCS.UU.SE>
  0 siblings, 1 reply; 3+ messages in thread

From: Sherril Mathew @ 2000-05-26 10:53 UTC (permalink / raw)
  To: pgsql-sql

Hi, my name is sherril .I have the following Question
My one feild in the database is Date/time  I want  to find a range of 
records which exists between two dates in  the same date field in the 
database
Also tell me how to retreive  all records from database where field which is 
date time is null I am working on ASP and backend as ms-ACCESS
My email Address is m_sherril@hotmail.com
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: A Question
  2000-05-26 10:53 A Question Sherril Mathew <m_sherril@hotmail.com>
@ 2000-05-26 12:48 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
  0 siblings, 0 replies; 3+ messages in thread

From: Peter Eisentraut @ 2000-05-26 12:48 UTC (permalink / raw)
  To: Sherril Mathew <m_sherril@hotmail.com>; +Cc: pgsql-sql

On Fri, 26 May 2000, Sherril Mathew wrote:

> My one feild in the database is Date/time  I want  to find a range of 
> records which exists between two dates in  the same date field in the 
> database

SELECT * FROM table WHERE datetime_field between '1999-03-15' and
'2000-10-23';

> Also tell me how to retreive  all records from database where field which is 
> date time is null I am working on ASP and backend as ms-ACCESS

SELECT * FROM table WHERE datetime_field is null;


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-05-26 12:48 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-02 14:23 A question Julie <j.baratchart@estia.fr>
2000-05-26 10:53 A Question Sherril Mathew <m_sherril@hotmail.com>
2000-05-26 12:48 ` Re: A Question Peter Eisentraut <e99re41@DoCS.UU.SE>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox