| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | markw <markw(at)mohawksoft(dot)com>, Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>, pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL |
| Date: | 2000-11-15 19:09:06 |
| Message-ID: | 3.0.1.32.20001115110906.00a15c00@mail.pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
At 01:53 PM 11/15/00 -0500, markw wrote:
>I'd rather not pollute the application's SQL with postgres-isms. Not that I
>don't love postgres, but there are always critics looking for a reason to use
>Oracle or (gasp) MS-SQL.
Define some global variable with the name of the database being run (currently
only Postgres) and guard the SET statement with a conditional...
In the OpenACS project we've got little functions that return query snippets
called things like "db_nextval" that return either "sequence_name.nextval"
or "nextval('sequence_name')" depending on whether the code's running
under Oracle or Postgres. That helps us minimize differences in the source.
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2000-11-15 19:13:14 | String substitution with "translate" function |
| Previous Message | markw | 2000-11-15 18:53:34 | Re: Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-11-15 19:15:09 | Re: Syslog Facility Patch |
| Previous Message | Mikheev, Vadim | 2000-11-15 19:01:49 | RE: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c) |