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 precisi
"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 onl
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?
-
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
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 Roui
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. I
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
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
subscr
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
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 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 fie
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 s
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 tr
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,
14 matches
Mail list logo
