Hello all,
I've a problem with escaping a \ in a string.
When I enter the query:
SELECT '''\\\''; I get the right result: '\'
But when I try this in a Function:
CREATE FUNCTION sp_tmp() RETURNS varchar(10)
AS '
SELECT ''\\\' AS RESULT'
LANGUAGE 'sql';
I get the following Parse-erros:
At 10:33 26/03/01 +0200, Mathijs Brands wrote:
>Has anybody ever tried calling Java code from a pgsql trigger written
>in C? Shouldn't this be possible using JNI?
This was discussed recently.
>I'm not exactly a Java expert myself, but this is the way PHP allows
>you to call Java code from your
On Thursday, 29. March 2001 01:38, David Olbersen wrote:
[snip]
> SELECT
> building_id,
> num_buildings,
> (
> SELECT count( building_id )
> FROM building_portals
> WHERE building_id = THIS.building_id
> )
> FROM buildings;
Try this query (untested), using
At 21:37 26/03/01 +0200, Mathijs Brands wrote:
>On Mon, Mar 26, 2001 at 07:00:43PM +0200, Peter Eisentraut allegedly wrote:
> > Mathijs Brands writes:
> >
> > > Has anybody ever tried calling Java code from a pgsql trigger written
> > > in C? Shouldn't this be possible using JNI?
> >
> > I have, a
On Wed, 28 Mar 2001, Marcos Minshew wrote:
> I am interested in using the SELECT ... FOR UPDATE feature but it doesn't
> work quite the way I had hoped. If there is a better/different way of doing
> this please enlighten me.
>
> If I issue:
>
> BEGIN;
> SELECT * FROM atable WHERE atable.key
On Wed, 28 Mar 2001, David Olbersen wrote:
> Hello,
>
> I have a feeling this isn't going to make much sense, but I'm gonig to try
> anyway.
>
> What I'd like to do is be able to refer to an outer-SELECT from an
> inner-SELECT. I hope this makes sense.
>
> I need to be able to refer
> [EMAIL PROTECTED] writes:
> > It doesn't getting different times on each execution. I also tried put
> > "timestamp 'now'" insted "now()". What am I doing wrong?
>
> now() is defined to return the time of the start of the current
> transaction. It won't change value inside a transaction
From: "Martijn van Dijk" <[EMAIL PROTECTED]>
> I've a problem with escaping a \ in a string.
>
> When I enter the query:
>
> SELECT '''\\\''; I get the right result: '\'
>
> But when I try this in a Function:
>
> CREATE FUNCTION sp_tmp() RETURNS varchar(10)
> AS '
> SELECT ''\\\' AS RESUL
On Thu, Mar 29, 2001 at 10:10:44AM +0100, Peter Mount allegedly wrote:
> At 21:37 26/03/01 +0200, Mathijs Brands wrote:
> >On Mon, Mar 26, 2001 at 07:00:43PM +0200, Peter Eisentraut allegedly wrote:
> > > Mathijs Brands writes:
> > >
> > > > Has anybody ever tried calling Java code from a pgsql tr
How does currval work if you are not inside a transaction. I have
been experimenting with inserting into a table that has a sequence.
If the insert fails (not using a transaction) because of bad client input
then the next insert gets the proper next number in the sequence.
given sequence 1,2,3
> How does currval work if you are not inside a transaction. I have
> been experimenting with inserting into a table that has a sequence.
> If the insert fails (not using a transaction) because of bad client input
> then the next insert gets the proper next number in the sequence.
If you are i
I ditto what Bruce said - trying to get a true sequence without gaps is a
losing battle. Why don't you, instead, use a serial column as the real
sequence, and then a trigger that simply inserts max(foo) + 1 in a
different column? Then when you need to know the column, do something
like:
SELECT nu
If you are looking to have every number accounted for, something like this
will work:
INSERT INTO table (serial_col) SELECT nextval('seq_serial_col');
UPDATE table SET foo = 'bar' , ... WHERE serial_col = (SELECT
currval('seq_serial_col'));
then, if the update fails, the number will be accounte
Peter Mount wrote:
>
> At 10:33 26/03/01 +0200, Mathijs Brands wrote:
>
> >Has anybody ever tried calling Java code from a pgsql trigger written
> >in C? Shouldn't this be possible using JNI?
>
> This was discussed recently.
>
> >I'm not exactly a Java expert myself, but this is the way PHP al
"Martijn van Dijk" <[EMAIL PROTECTED]> writes:
> But when I try this in a Function:
> CREATE FUNCTION sp_tmp() RETURNS varchar(10)
> AS '
> SELECT ''\\\' AS RESULT'
> LANGUAGE 'sql';
> I get the following Parse-erros:
You need an extra level of quoting because the function body is itsel
A James Lewis writes:
> Before I go investigating this, is it possible to trigger an arbitrary
> program from the SQL, say a shell script?
At the lowest level, you can generally do anything a C program can do.
Writing the equivalent of system() in SQL should be rather trivial.
You can also take
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> A James Lewis writes:
>> Before I go investigating this, is it possible to trigger an arbitrary
>> program from the SQL, say a shell script?
> At the lowest level, you can generally do anything a C program can do.
> Writing the equivalent of system()
I am trying to do an update on column in a table with 1.5 millions rows.
The SQL is as follows, I am also putting it in a transaction in case things
go wrong.
begin;
update statistics set parameters = NULL where parameters ='';
An explain produces the following: -
Seq Scan on statistics (cost=
Probably just me: but I don't see the point. Consider:
* User 1 commences insert transaction: grabs nextval(sequence),
max(foo)
* User 2 commences insert transaction: grabs nextval(sequence),
max(foo)
* User 1 commits
* User 2 commits (insert has sequence value one higher
Tom Lane writes:
> I'm generally pretty suspicious of any system design that requires
> calling outside programs from an SQL function. The problem is that
> this fundamentally breaks transactional semantics: if the transaction
> is rolled back after the function call, its effects inside the data
Here's a fragment of code that works on 7.0.3 but gives a type mismatch
on 7.1:
Under 7.1RC1, func1 fails and func2 builds OK. The error is:
ERROR: return type mismatch in function: declared to return int4,
returns numeric
It appears that sum(int4) returns type numeric. Shouldn't it return
int
> > I've a problem with escaping a \ in a string.
> >
> > When I enter the query:
> >
> > SELECT '''\\\''; I get the right result: '\'
> >
> > But when I try this in a Function:
> >
> > CREATE FUNCTION sp_tmp() RETURNS varchar(10)
> > AS '
> > SELECT ''\\\' AS RESULT'
> > LANGUAGE 'sql';
Hi all, here is error I that am getting:
pg_dump -s mondo > mondo.out
PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
I faced similar example in the past too. At that time, there was a
referentional constraint problem but this situation is different.
I am usning postgres 7.0.3 on redh
Phuong Ma <[EMAIL PROTECTED]> writes:
> I'm using PostgreSQL version 7.1, and I'm having trouble with the LIKE
> statement. How would I find the value "a\bc"? I tried using the
> backslash to escape it: LIKE 'a\\b%';
I think you need four backslashes. The string-literal parser eats one
level o
I'm using PostgreSQL version 7.1, and I'm having trouble with the LIKE
statement. How would I find the value "a\bc"? I tried using the
backslash to escape it: LIKE 'a\\b%';
If I specify: LIKE 'a\\bc', then it works, but if I wanted it to look
for consecetive characters after the c, using the %,
> > I don't think that we dare try to make any basic changes in
> > MVCC for 7.1 at this late hour, so Forest is going to have
> > to live with that answer for awhile. But I would like to see
> > a cleaner answer in future releases.
>
> Is it the MVCC's restriction that each query inside a functi
Hello:
I'm using postgres 7.0.2. When I use date_part('day', date) sometimes I
get wrong values. Ie:
and date_part('day', '1999-3-28')=27
and date_part('day', '2000-3-26')=25
Is it a bug? Is there any SQL equivalent function?
--
Salvador Mainé
---(end of broadcast)--
Has anyone tried setting up Postgres as a linked server under Microsofts SQL
Server 7 to connect with SQL 6.5
I am able to create the link correctly (see below) and see all the tables
available in Postgres, but if I try querying anything in them I get the
following error
Server: Msg 7313, Level
At 09:58 28/03/01 -0800, Mikheev, Vadim wrote:
>
>Reported problem is caused by bug (only one tuple version must be
>returned by SELECT) and this is way to fix it.
>
I assume this is not possible in 7.1?
Philip Warner
Philip Warner wrote:
>
> At 19:14 29/03/01 -0800, Mikheev, Vadim wrote:
> >> >Reported problem is caused by bug (only one tuple version must be
> >> >returned by SELECT) and this is way to fix it.
> >> >
> >>
> >> I assume this is not possible in 7.1?
> >
> >Just looked in heapam.c - I can fix it
At 19:14 29/03/01 -0800, Mikheev, Vadim wrote:
>> >Reported problem is caused by bug (only one tuple version must be
>> >returned by SELECT) and this is way to fix it.
>> >
>>
>> I assume this is not possible in 7.1?
>
>Just looked in heapam.c - I can fix it in two hours.
>The question is - shoul
> Just looked in heapam.c - I can fix it in two hours.
> The question is - should we do this now?
This scares the hell out of me.
I do NOT think we should be making quick-hack changes in fundamental
system semantics at this point of the release cycle.
The problem went unnoticed for two full rel
At 13:16 30/03/01 +0900, Hiroshi Inoue wrote:
>Philip Warner wrote:
>>
>> At 19:14 29/03/01 -0800, Mikheev, Vadim wrote:
>> >> >Reported problem is caused by bug (only one tuple version must be
>> >> >returned by SELECT) and this is way to fix it.
>> >> >
>> >>
>> >> I assume this is not possible
33 matches
Mail list logo
