?, ?& and ?| operators
http://www.postgresql.org/docs/9.3/static/hstore.html
Cheers
--
Matteo Beccati
Development & Consulting - http://www.beccati.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
about:
PREPARE test (varchar) as select * from test where a = $1;
EXECUTE test(test_immutable(1));
Cheers
--
Matteo Beccati
Development & Consulting - http://www.beccati.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ld replicate the issue.
Thanks everyone for the help and explanations!
Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I was thinking to the opposite, but at least one of them didn't
use --enable-integer-datetimes. I could understand problems representing
microseconds, but not the time zone...
Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com
---(end of broadcast)---
Matteo Beccati ha scritto:
> Hi,
>
> I've been recently pointed out an issue with timestamptz on a fedora box
> and no one was able to replicate it on other machines. After a quick
> chat on the IRC at least another two people could replicate the issue
> and all of them we
01-10 00:00:00+01
(2 rows)
Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
under GPL.
Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
messa
Hi,
l = 38;
This should be:
l := 38;
otherwise l would remain uninitialized (NULL).
Ciao ciao
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
Hi,
Can I get PHP to remove the first row without reading the whole file in? If
there was a way where PHP would just chop the first row off that would be
ideal...
If you are using "COPY table FROM stdin" and pg_put_line() it's not much
difficult to skip the first line ;)
Best re
ostgres tries to add the missing table name, so your query
get rewritten as:
select foo.c1, f.c2 from foo f, foo;
You should also receive a:
NOTICE: adding missing FROM-clause entry for table "foo"
Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.
Hi,
à (UTF-8 encoded)
Sorry, I actually forgot to switch encoding :)
I just hope the last part of the email was readable.
Ciao ciao
--
Matteo Beccati
http://phpadsnew.com/
http://phppgads.com/
---(end of broadcast)---
TIP 3: if posting/reading
. In fact, INSERTs were sometimes failing because of
concurrency, and this was the only viable solution I found to avoid
losing data.
Best regards
--
Matteo Beccati
http://phpadsnew.com/
http://phppgads.com/
---(end of broadcast)---
TIP 3: if posting
12 matches
Mail list logo