On Sun, 2006-10-08 at 01:44 -0400, Tom Lane wrote:
Yeah: current_user (without the parens) is specified by the SQL
standard, but we're not about to adopt such a brain-dead syntax
for any of the functions defined by Postgres itself --- as you
I see. One of committee's work gems :(
And yet,
On Thu, Oct 05, 2006 at 05:08:27PM -0600, Leonel Nunez wrote:
Subject: Re: [GENERAL] Storing images in PostgreSQL databases (again)
User-Agent: SquirrelMail/1.4.8
Leonel Nunez wrote:
I think the arguments for keeping stuff inside the database are
(a) far easier to maintain transactional
On Fri, 6 Oct 2006 18:12:22 -0700 (PDT)
Richard Broersma Jr [EMAIL PROTECTED] wrote:
Is there any good documentation, example, tutorial, pamphlet,
discussion... to exploit pg features to obtain polymorphic
behavior without renouncing to referential integrity?
Inheritance seems *just*
On Fri, Oct 06, 2006 at 11:09:29PM +0200, Ivan Sergio Borgonovo wrote:
Is there any good documentation, example, tutorial, pamphlet, discussion...
to exploit pg features to obtain polymorphic behavior without renouncing to
referential integrity?
In GNUmed we use it to aggregate text fields
Hi, Martijn
I think I mis-understand the UTF-8 sorting in different collation by culture. I google the utf8 +chinese +sort and find some basic information about the sorting in the UTF8. I think the UTF8 encoding sorting result use the sql statement "order by column" on the solaris maybe correct.
On Sun, 8 Oct 2006 14:09:53 +0200
Karsten Hilbert [EMAIL PROTECTED] wrote:
On Fri, Oct 06, 2006 at 11:09:29PM +0200, Ivan Sergio Borgonovo
wrote:
Is there any good documentation, example, tutorial, pamphlet,
discussion... to exploit pg features to obtain polymorphic
behavior without
a2hosting.com offers tsearch2 and recent versions for PostgreSQL
hosting.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
I want to create a function in PL/SQL as
CREATE OR REPLACE FUNCTION f_do (text, double precision[]) RETURNS
double precision AS '
DECLARE
f text := $1;
p double precision[] := $2;
res double precision;
BEGIN
SELECT f(p) into res;
RETURN res;
END;' LANGUAGE plpgsql
STABLE
Ok, Ok, Ok,
Practical PostgreSQL, Chapter 5, date_part(), to_char()
I got it :-)-O
el
on 10/8/06 9:43 AM Eberhard Lisse said the following:
Thank you very much.
Sorry to be unclear, they are time stamped, and I wondered if someone
could give me ssome advise how I do this aggregation. In
Thank you very much.
Sorry to be unclear, they are time stamped, and I wondered if someone
could give me ssome advise how I do this aggregation. In particular do
I not know how to write such a scalar function.
Anything re-usable lying around as examples somewhere?
el
on 10/4/06 9:46 PM Guy
Is it possible to automatically detect the language encoding of incoming data? For instance if Japanese is used, is there a way to know it is Japanese from a bit in the charset, a dictionary-based evaluation or otherwise?
All-new Yahoo! Mail - Fire up a more powerful email and get things done
I get an error message 55000 when I try to traverse backwards in an
refcursor. Works fine going forward. The hint says I need to use
scroll. What is the syntax for using scroll in a stored procedure that
returns an refcursor? Or do refcursors only support traversing forward?
Karen Hill [EMAIL PROTECTED] writes:
I get an error message 55000 when I try to traverse backwards in an
refcursor. Works fine going forward. The hint says I need to use
scroll. What is the syntax for using scroll in a stored procedure that
returns an refcursor? Or do refcursors only
On Sun, Oct 08, 2006 at 05:49:11PM +0200, Jean-Gerard Pailloncy wrote:
I want to create a function in PL/SQL as
CREATE OR REPLACE FUNCTION f_do (text, double precision[]) RETURNS
double precision AS '
DECLARE
f text := $1;
p double precision[] := $2;
res double precision;
14 matches
Mail list logo