Hi!
When I store special caracters from spanish language I have problems when I
got it back because it do not return what I have stored.
Is some available support for that in postgres 7.0.2?
thank you,
Rocael.
Get free email
Tom Lane <[EMAIL PROTECTED]> writes:
> Christophe Boyanique <[EMAIL PROTECTED]> writes:
> > SELECT idProduct FROM products
> > WHERE idProduct IN
> > (SELECT id FROM orders WHERE ts>'2000-10-01 17:04:00'
> > UNION SELECT id FROM preorders WHERE ts>'2000-10-01 17:04:00')
> > ORDER by n
Tom Lane wrote :
> Current releases don't handle UNION in sub-selects. 7.1 will.
Thanks very much for this "fast as speed light" answer !
Is there an idea about the 7.1 release date ? Just to know if this is
will be in weeks, months or years...
Christophe.
Christophe Boyanique <[EMAIL PROTECTED]> writes:
> SELECT idProduct FROM products
> WHERE idProduct IN
> (SELECT id FROM orders WHERE ts>'2000-10-01 17:04:00'
> UNION SELECT id FROM preorders WHERE ts>'2000-10-01 17:04:00')
> ORDER by name;
> and I've got a parse error near UNION or S
Hello,
I've got a problem with UNION and SELECT IN
I have a first table:
CREATE TABLE products
(
idProduct INT4,
nameVARCHAR(32)
);
and two others tables:
CREATE TABLE orders
(
id INT4,
ts TIMESTAMP
);
CREATE TABLE preorders
(
id INT4,
ts
> Probably a very simple question, but how do you define a function that
> returns the sucess of an insert or update in a function i.e.
>
> CREATE FUNCTION foo ( varchar, int8 ) RETURNS bool
> AS 'UPDATE table WHERE something'
> LANGUAGE 'sql';
With SQL functions you can't (as far as I kn
> I wonder if there couldn't borrowed some code from Interbase which has
> full featured stored procedures - at least it was told to me that it has
> ...
Well, I have some hands-on experience with IB, don't know whether this is
perfectly relevant, but here goes
Indeed, stored procedures
Probably a very simple question, but how do you define a function that
returns the sucess of an insert or update in a function i.e.
CREATE FUNCTION foo ( varchar, int8 ) RETURNS bool
AS 'UPDATE table WHERE something'
LANGUAGE 'sql';
Cheers
Graham
>>> Josh Berkus <[EMAIL PROTECTED]> 09.11.2000 17.40 Uhr >>>
> Tom, Bruce, Jan, etc.:
>
> As a PGSQL developer and business customer, I wanted to make some
> public requests as to the development path of PGSQL. While, obviously,
> you will develop the functionality *you* are interested in,
