Re: [GENERAL] Documentation of nitty gritty stuff. - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: [GENERAL] Documentation of nitty gritty stuff.
Date
Msg-id 3.0.5.32.19991201103612.0088bdd0@pop.mecomb.po.my
Whole thread Raw
List pgsql-general
Hi,

Where should I look in the documentation for how to "quote" data for Postgres?
e.g.
Quoting quotes..
select * from t where x='It''s hard to find'

Quoting Likes- trying to find backslashes-
 select * from t where x like '%\\%' ?

Also more information on limits of data/types would be good - serial,
character types. Can characters store 8 bit data safely. If not, can we
kludge it with numeric..

How to get datetime to show the famed 1 microsecond resolution- "order by"
doesn't seem to work.

There's quite a bit of good info in the current Postgres docs, but it seems
to gloss over some nitty gritty details.

Cheerio,

Link.


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] "FATAL 1: my bits moved right off the end of theworld!"
Next
From: Manuel Cabido
Date:
Subject: Re: pgsql-general-digest V1 #550