| From: | Lincoln Yeoh <lylyeoh(at)mecomb(dot)com> |
|---|---|
| To: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Documentation of nitty gritty stuff. |
| Date: | 1999-12-01 02:36:12 |
| Message-ID: | 3.0.5.32.19991201103612.0088bdd0@pop.mecomb.po.my |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manuel Cabido | 1999-12-01 09:53:52 | Re: pgsql-general-digest V1 #550 |
| Previous Message | Bruce Momjian | 1999-12-01 00:27:46 | Re: [GENERAL] "FATAL 1: my bits moved right off the end of theworld!" |