from f_aliastest();
Is there a way that I can make my function return the field aliases?
Best wishes from Berlin,
Maximilian Tyrtania
http://www.contactking.de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Am 16.10.2012 um 11:37 schrieb hubert depesz lubaczewski dep...@depesz.com:
create or replace function f_aliastest(OUT alias TEXT) returns setof record
AS …
Ah, yes, I forgot about the OUT parameters, thanks for the reminder!
Maximilian Tyrtania
Contact King Software Entwicklung
Maximilian
but to return query in general.
Maximilian Tyrtania
http://www.contactking.de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
GmbH
(1 row)
What might be up there?
Maximilian Tyrtania
http://www.contactking.de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Aug 27, 2012 at 12:55 PM, Maximilian Tyrtania
li...@contactking.de wrote:
What might be up there?
It might be a broken index issue. Please show the EXPLAIN for these queries.
It was. I had an index like this:
CREATE INDEX idx_firmen_iskunde_index
ON firmen
USING btree
On Mon, Aug 27, 2012 at 12:55 PM, Maximilian Tyrtania
li...@contactking.de wrote:
What might be up there?
It might be a broken index issue. Please show the EXPLAIN for these queries.
It was. I had an index like this:
CREATE INDEX idx_firmen_iskunde_index
ON firmen
USING btree
Am 27.08.2012 um 16:18 schrieb Tom Lane t...@sss.pgh.pa.us:
Maximilian Tyrtania li...@contactking.de writes:
Sorry, should have mentioned that…Dropping and recreating it fixed it.
Hm, had you changed the behavior of that function since creating the
index?
To be honest - I don't know
: *** [twitter_fdw.so] Fehler 1
root@contactkingserver:/usr/local/pgsql/bin/twitter_fdw-1.1.1#
Looks like some problem with libjson-0.8 but the directory is there.
The readme says: The source of libjson is included this module package and
linked as a
static library
Any pointers?
Maximilian Tyrtania
Hi there,
i'd like to figure out if my pg server (9.0.2) running on OpenSuse has been
compiled with gssapi support. The PG OpenSuse package seems to not ship
pg_config for some reason.
Is there another way to determine that?
Maximilian Tyrtania
http://www.contactking.de
--
Sent via pgsql
Am 26.03.2012 um 11:34 schrieb John R Pierce:
On 03/26/12 2:22 AM, Maximilian Tyrtania wrote:
i'd like to figure out if my pg server (9.0.2) running on OpenSuse has been
compiled with gssapi support. The PG OpenSuse package seems to not ship
pg_config for some reason.
the redhat packages
Am 26.03.2012 um 15:09 schrieb Adrian Klaver:
On 03/26/2012 03:01 AM, Maximilian Tyrtania wrote:
Am 26.03.2012 um 11:34 schrieb John R Pierce:
On 03/26/12 2:22 AM, Maximilian Tyrtania wrote:
i'd like to figure out if my pg server (9.0.2) running on OpenSuse has
been compiled with gssapi
doesn't like that:
ERROR: SQL functions cannot have arguments of type record. It also doesn't
work with plpgsql.
Is there a way?
Best wishes from Berlin,
Maximilian Tyrtania
Maximilian Tyrtania Software-Entwicklung
10969 Berlin
http://www.contactking.de
--
Sent via pgsql-general mailing list
Am 04.03.2011 um 11:01 schrieb Craig Ringer:
On 04/03/11 00:02, Maximilian Tyrtania wrote:
After upgrading to pg 9.0.3 (from 8.4.2) on my Mac OS 10.6.2 machine i find
this in my log file (a lot):
postgres%192.168.254.210%2011-03-03 16:37:30 CET%22021STATEMENT: SELECT
pg_file_read
-UTF8' before), but that doesn't appear to help. The
Server encoding is UTF8. No special client encoding is set.
Any help would be appreciated,
Max
Maximilian Tyrtania Software-Entwicklung
Dessauer Str. 6-7
10969 Berlin
http://www.contactking.de
--
Sent via pgsql-general mailing list (pgsql
on different machines. Had to change the password via the passwd utility.
Anyone else seen this?
Maximilian Tyrtania Software-Entwicklung
Dessauer Str. 6-7
10969 Berlin
http://www.contactking.de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Unix user account named (by default) 'postgres'.
Yes. What confused me is: The installer seems to change the passsword of an
already existing postgres user on that machine to . Did i understand that
correctly? Should it really do that?
Maximilian Tyrtania Software-Entwicklung
Dessauer Str. 6-7
/plpgsql-statements.html
Max
Maximilian Tyrtania Software-Entwicklung
Dessauer Str. 6-7
10969 Berlin
Tel.:++49/30/48827-952
Mobil: 0152/292 707 36
email: maximilian.tyrta...@byte-employer.de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
);
Not an ideal solution, but it seems to perform quite well.
Best wishes from Berlin,
Maximilian Tyrtania
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
(text) OWNER TO postgres;
Then create an index like this:
create index idx_personen_nachname_orderByFriendly on personen
(f_getorderbyfriendlyversion(nachname))
Now you can do:
select * from personen order by f_getorderbyfriendlyversion(p.nachname)
Seems pretty fast.
Best,
Maximilian Tyrtania
;
As far as I can see i followed the escaping rules given in
http://www.postgresql.org/docs/current/static/datatype-binary.html
Thanks,
Maximilian Tyrtania
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
settings as root.
Maximilian Tyrtania | IT-Entwickler
[EMAIL PROTECTED]
fischerAppelt Kommunikation GmbH
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, and if so,
how i can change the systems settings as root.
Do you use TCP/IP socket when you execute SHOW ALL? Those parameters
are ignored via Unix-domain socket.
Yes, i am using a tcp/ip socket. Sorry, should have mentioned that.
Thanks,
Maximilian Tyrtania
--
Sent via pgsql-general
22 matches
Mail list logo