hai all, i'm trying create function like this
CREATE OR REPLACE FUNCTION penjualan(idcb integer)
RETURNS SETOF penjualan AS
$BODY$
BEGIN
IF ($1 IS NULL) THEN
return query SELECT * FROM PENJUALAN;
ELSE
return query SELECT * FROM PENJUALAN WHERE IDCABANG=$1;
END IF;
END;
$BODY$
LANGUAGE 'plpg
I would see if you could trim down the statement and keep the statement all on
one
line (if possible)
if you cant trim it down try putting the logic in a function
HTH
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any
On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote:
> When I run the following query through psql, it executes successfully.
> However, when I run it through ODBC (via OpenOffice Base), I get the error
>
> SQL Status: HY000
> Error code: 1000
>
> syntax error, unexpected $end, expecting BETWEE
On Sun, 2009-03-15 at 01:48 +0100, Marco Colombo wrote:
> Joshua D. Drake wrote:
> > On Sat, 2009-03-14 at 05:25 +0100, Marco Colombo wrote:
> >> Scott Marlowe wrote:
> >
> >> Also see:
> >> http://lkml.org/lkml/2008/2/26/41
> >> but it seems to me that all this discussion is under the assuption t
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Carl Sopchak
> Sent: Saturday, March 14, 2009 5:41 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] ODBC limitation??
>
> When I run the following query thr
Joshua D. Drake wrote:
> On Sat, 2009-03-14 at 05:25 +0100, Marco Colombo wrote:
>> Scott Marlowe wrote:
>
>> Also see:
>> http://lkml.org/lkml/2008/2/26/41
>> but it seems to me that all this discussion is under the assuption that
>> disks have write-back caches.
>> "The alternative is to disable
When I run the following query through psql, it executes successfully.
However, when I run it through ODBC (via OpenOffice Base), I get the error
SQL Status: HY000
Error code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
Is this some limitation of ODBC? (I do
Hi,
The video is now available for download! You can find it at:
http://blog.thebuild.com/sfpug/sfpug-unison-20090311.mov
Thanks,
-- Christophe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpre
>> Will there be a saved version of this (SFPUG talk) available for later
>> viewing? Don't
>> make me choose between steak and beer and postgres. 8(
>
> Yes! I'll announce it here when it's available.
>
Is there any update on this?
-Nathan
--
Sent via pgsql-general mailing list (pgsql-genera
Queridos amigos e amigas,
Dia 21/3, farei 32 anos e comemorarei em 3 ocasiões!
Na 6a feira (20/3), espero vocês no Happy Hour da Gafieira Lapa 40 Graus (Rua
do Riachuelo, 97) no 1º andar, estarei lá a partir das 19h. A casa conta com
mesas de sinuca e shows ao vivo. A entrada é de apenas R$
Hi All,
Acting on a customer's report I analyzed this bug, and have found a fix
for it. It is not a critical error, but it definitely is a bug, and can have
security implications.
This error is raised from syslogger.c, and since this sub-process is not
responsible for any backend communic
On Sat, 2009-03-14 at 05:25 +0100, Marco Colombo wrote:
> Scott Marlowe wrote:
> Also see:
> http://lkml.org/lkml/2008/2/26/41
> but it seems to me that all this discussion is under the assuption that
> disks have write-back caches.
> "The alternative is to disable the disk write cache." says it a
Hi,
As we are moving very close to 8.4 beta, please join us for testing 8.4
release.
I just released new RPM sets, which is based on Mar 10 CVS snapshot.
Please note that these packages are **not** production ready. They are
for Fedora 9 and RHEL/CentOS 5. I have no intention to push 8.4
developm
13 matches
Mail list logo
