Hi all.
I know that the output of a decrypt() call (from pgcrypto module) can
be safely converted to TEXT.
CAST( decrypt( data,key,'bf' ) as TEXT ) (and other variants) just doesn't work.
How can I (possibly easily) do it?
Thanks.
--
Sent via pgsql-general mailing list
What is the different between pg_trgm search and FULL Text search?
Anyone has idea on these, please let me know.
On 23 Duben 2012, 13:31, AI Rumman wrote:
What is the different between pg_trgm search and FULL Text search?
Anyone has idea on these, please let me know.
pg_trgm performs trigram matching i.e. determines similarity of strings
based on trigrams (three-character strings). It has no notion of a
2012/4/23 Vincenzo Romano vincenzo.rom...@notorand.it:
Hi all.
I know that the output of a decrypt() call (from pgcrypto module) can
be safely converted to TEXT.
CAST( decrypt( data,key,'bf' ) as TEXT ) (and other variants) just doesn't
work.
How can I (possibly easily) do it?
Thanks.
[redirected to pgsql-general]
On 04/23/2012 09:42 AM, Krzysztof Nienartowicz wrote:
Hello,
Sorry for re-posting - I initially posted this in pgsql.sql - probably
this group is more appropriate.
pgsql-general probably would be best. -hackers is for discussion of
internals and development,
There are obviously workarounds for this, but I'm wondering why the
following query shouldn't work. It seems like it should. With MVCC already
present on the back-end, I can't see any reason other than additional
parsing routines that this couldn't work:
INSERT INTO
On 23 April 2012 21:49, Nick Apperson apper...@gmail.com wrote:
There are obviously workarounds for this, but I'm wondering why the
following query shouldn't work. It seems like it should. With MVCC already
present on the back-end, I can't see any reason other than additional
parsing routines
On Tue, Apr 24, 2012 at 6:49 AM, Nick Apperson apper...@gmail.com wrote:
There are obviously workarounds for this, but I'm wondering why the
following query shouldn't work. It seems like it should. With MVCC already
present on the back-end, I can't see any reason other than additional
parsing
On Tue, Apr 24, 2012 at 08:12:10AM +1000, Chris Angelico wrote:
On Tue, Apr 24, 2012 at 6:49 AM, Nick Apperson apper...@gmail.com wrote:
There are obviously workarounds for this, but I'm wondering why
the following query shouldn't work. It seems like it should. With
MVCC already present on
On Tue, Apr 24, 2012 at 11:30 AM, David Fetter da...@fetter.org wrote:
On Tue, Apr 24, 2012 at 08:12:10AM +1000, Chris Angelico wrote:
Of course, the question I never asked (never bothered to, really)
was: Is it really any better than simply doing the first insert and
retrieving the ID in my
You can have INSERT ... SELECT RETURNING ... as a query in Postgres.
The RETURNING applies to the INSERT. See:
CREATE TABLE foo(i INT);
INSERT INTO foo(i) SELECT generate_series(1,5) RETURNING i;
Anyway, CTEs might work, but I can't see any good way to pass the
association through without
11 matches
Mail list logo