)
frombar
...will give you values in column foo rounded to 2 decimal places.
--
Rodger Donaldson[EMAIL PROTECTED]
I don't mind straight people, as long as they act gay in public
---(end of broadcast)---
TIP 8: explain analyze
, everything except the date gets truncated.
--
Rodger Donaldson[EMAIL PROTECTED]
My ATEX terminal isn't working
Is there power to the keyboard?
No, and it has smoke and flames coming out of it
---(end of broadcast)---
TIP 5: Have you
On Wed, Feb 05, 2003 at 11:22:57PM -0500, Tom Lane wrote:
Rodger Donaldson [EMAIL PROTECTED] writes:
values (to_date('06/Feb/2003:11:29:11 +13', 'DD/Mon/:HH24:MI:SS'),0,302,
Always inserts the correct date, but sets the time to midnight.
Um, well, yeah ... it's to_DATE, meaning
On Tue, 28 Jan 2003, Rodger Donaldson wrote:
Now, adding a UNIQUE constraint on the pk for add_queue weeds out
dupes there. However, attempting to add a cross-table UNIQUE check
with:
alter table add_queue add constraint add_queue_no_dupe_sites unique
(sites.url);
ERROR: parser
) to
preprocess your data.
The DBD::CSV module allows one to use a subset of SQL syntax on CSV
files, as an example. Docs are at
http://search.cpan.org/author/JZUCKER/DBD-CSV-0.2002/lib/DBD/CSV.pm
--
Rodger Donaldson
[EMAIL PROTECTED]
---(end of broadcast
.
The other aspect of this is that it seems that postgresql's regexp engine
doesn't understand some expected regexps; I've tried both escaped and
unescaped versions of, eg \w, \s, \n and so on a pg seems to ignore them.
Am I exceeding the capabilities of the regexp parser?
--
Rodger Donaldson