Don't invent a wheel and use contrib/tsearch2 for that.
On Tue, 13 Jun 2006, Aaron Bono wrote:
In another post on a different topic, Rod Taylor said the following:
"A\tcat in the\nhat" might be stored as ARRAY['A', 'cat', 'in', 'the',
'hat'].
This got me thinking. I have a discussion for
O Oleg Bartunov έγραψε στις Jun 14, 2006 :
> Don't invent a wheel and use contrib/tsearch2 for that.
Hi Oleg,
i just wanted to ask if anything close to
exact phrase matching could be deployed/implemented with tsearch2.
>
> On Tue, 13 Jun 2006, Aaron Bono wrote:
>
> > In another post on a dif
On Tue, 13 Jun 2006, Aaron Bono wrote:
I will look that tsearch (at . It appears their 8.1.x version is
still in development and I use PostgreSQL 8.1.3 but it is worth trying
- I'm not in a hurry for that feature anyway.
I also looked at PHPBB a little - it appears their database stores
words
hi.
When I execute "SELECT specification FROM armature WHERE id = 96;"
query I get WARNING: ignoring unconvertible UTF-8 character 0xe28093.
How can I replace this (0xe28093) char with another one?
---(end of broadcast)---
TIP 9: In versions below
Hi Listers,
I want to use prepared statement in a function. Here is my code:
create or replace function generate_data
( integer, integer )
returns integer
as
$BODY$
declare
p_count alias for $1;
p_max_value_id1 alias for $2;
am 14.06.2006, um 15:12:36 +0200 mailte Milen Kulev folgendes:
> How to solve my problem ? Is it possible at all to call prepared statement
> inside a function at all?
Yes, i have a example:
create or replace function foo() returns text as $$
declare sql text;
begin
sql := 'prepare bla(
That character is the EN Dash. Are you by chance copying and pasting
from MS Word or some other program that does smart replace while you
type? I don't see this character in your select. Is there something
else that is running that may be causing this problem?
-Aaron
On 6/14/06, Sergey Levche
"Milen Kulev" <[EMAIL PROTECTED]> writes:
> I want to use prepared statement in a function.
Why? You seem not to be aware that plpgsql implicitly prepares
statements behind the scenes.
> prepare mystmt( int, int, varchar) as insert into part
> values ($1,$2,$3);
>
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Wednesday, June 14, 2006 4:35 PM
To: Milen Kulev
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Prepared statements in PGSQL functions
"Milen Kulev" <[EMAIL PROTECTED]> writes:
>> I want t
Hi
Can somebody direct me to the mailing list for slony. I couldn't find
it anywhere on the postgres.org website (which is where I found this
list to begin with). Thanks
Mark
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 13, 2006 20:27
To: Mark Adan
try www.slony.info
-- Original Message ---
From: "Mark Adan" <[EMAIL PROTECTED]>
To:
Sent: Wed, 14 Jun 2006 08:50:23 -0700
Subject: Re: [SQL] Good examples of calling slony stored procedures
> Hi
>
> Can somebody direct me to the mailing list for slony. I couldn't find
> it
Hi Jim
I looked there already and didn't find what I needed. I saw this web
page from cbbrowne and he briefly talked about using "bare metal" slony
functions, but doesn't have any examples.
Mark
-Original Message-
From: Jim Buttafuoco [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14
On Wed, Jun 14, 2006 at 08:55:21AM -0700, Mark Adan wrote:
> Hi Jim
>
> I looked there already and didn't find what I needed. I saw this web
But the mailing list link is at the top of that page:
http://gborg.postgresql.org/mailman/listinfo/slony1
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Inf
Excellent. I will subscribe to that one. Thanks
Mark
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan
Sent: Wednesday, June 14, 2006 09:14
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Good examples of calling slony stored procedures
On Wed, 14 Jun 2006, Achilleus Mantzios wrote:
O Oleg Bartunov ?? Jun 14, 2006 :
Don't invent a wheel and use contrib/tsearch2 for that.
Hi Oleg,
i just wanted to ask if anything close to
exact phrase matching could be deployed/implemented with tsearch2.
not yet, but doable, sinc
Hello everyone:
We are working with serials fields and we found a
problem with then: When we insert in a table that has e unique restrict, and
this makes insert fails, the sequence increments anyway…¿What we can do
about it?
We hope you can help us…..
Alexis Palma Espinosa.
In
Alexis Palma Espinosa wrote:
Hello everyone:
We are working with serials fields and we found a problem with then:
When we insert in a table that has e unique restrict, and this makes
insert fails, the sequence increments anyway...¿What we can do about
it?
Nothing. The whole point of sequence
On Wednesday 14 June 2006 02:02 pm, "Alexis Palma Espinosa" <[EMAIL PROTECTED]>
thus communicated:
--> Hello everyone:
-->
-->
-->
--> We are working with serials fields and we found a problem with then: When
we insert in a table that has e unique restrict, and this makes insert
fails, the seque
Hi
,
This is Mark with ProV
International, This email is in regards to the requirement we have with
one of our direct client in San Diego,
CA.
PostgreSQL
Database Developer
This
position involves creating tables, views, functions and stored procedures to
support front end O
"Mark" <[EMAIL PROTECTED]> writes:
> This is Mark with ProV International, This email is in regards =
> to the requirement we have with one of our direct client in San Diego, =
> CA.
This is off-topic for pgsql-sql. Please use pgsql-jobs for this type of
message in future.
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Mark Adan")
wrote:
> I looked there already and didn't find what I needed. I saw this web
> page from cbbrowne and he briefly talked about using "bare metal" slony
> functions, but doesn't have any examples.
If you look at the source
21 matches
Mail list logo
