I have used PL/SQL for years. It's a great language that is easy to pick up and offers lots of ability/promise. The syntax seems very easy for new people to pick up who might know another language or are just starting out. Of course the same can be said of Ada code. It's just very easy to read.
> Out of curiosity, what other backends do you consider and what is their
> syntax for such problems.
Most folks that use Oracle's PL/SQL like it. I have a sneaking suspicion
Oracle used the GNAT parser for Ada as a starting point, but that is pure
conjecture. Oracle does document that PL/SQL is
Tony Caduto wrote:
> There are very nice inexpensive alternatives to PG Admin III. Because
> of it's cross platform nature it is severly lacking in many areas.
>
In what way does making software cross-plaform cause it to be 'lacking
in many areas'?
> Check out PG Lightning Admin at:
> http://ww
"Jason Tesser" <[EMAIL PROTECTED]> writes:
> Question: DO I have to define every column I am returning as an out
> going parameter?
Well, yes, where else is the system going to get the information?
regards, tom lane
---(end of broadcast)--
: Thursday, June 30, 2005 5:20 PM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] COnsidering a move away from Postgres
"Jason Tesser" <[EMAIL PROTECTED]> writes:
> Problem I ran your test and I am getting as error see below
This is an 8.1 feature not somet
"Jason Tesser" <[EMAIL PROTECTED]> writes:
> Problem I ran your test and I am getting as error see below
This is an 8.1 feature not something that exists in current releases.
regards, tom lane
---(end of broadcast)---
TIP 7:
OK I am an idiot you are running a cvs build I guess. Which at least
answers the problem.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do
ROR: CREATE FUNCTION / OUT parameters are not implemented
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 3:57 PM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] COnsidering a move away from Postgres
Jason Tesser <
On 6/30/05, Jason Tesser <[EMAIL PROTECTED]> wrote:
> I work for a college and we use PG currently as our main backend. We are
> currently developing with Java. We are considering moving away from postgres
> for the reasons I am going to list below. I would appreciate some thoughts
> from the Po
Jason Tesser <[EMAIL PROTECTED]> writes:
> I might be missing it but how does this help me. What I would like is to be
> able to return multiple records from a select statement that return multiple
> columns from different tables without having to create a type.
You mean like this?
regression=
Sven Willenberger <[EMAIL PROTECTED]> writes:
> As far as hard coding the OUT datatypes, if I understand the docs
> correctly you can even:
> CREATE FUNCTION foo(IN i int, OUT x anyelement, OUT y anyelement, OUT z
> anyelement) AS ...
That exact example would not work --- anyelement/anyarray is al
There are very nice inexpensive alternatives to PG Admin III. Because
of it's cross platform nature it is severly lacking in many areas.
Check out PG Lightning Admin at:
http://www.amsoftwaredesign.com
3. The tools. PgAdmin does some things well but it is lacking the features of
some of the
Tom Lane napisał(a):
Jason Tesser <[EMAIL PROTECTED]> writes:
3. The tools. PgAdmin does some things well but it is lacking the features of
some of the other gui tools.
I'm sure the pgAdmin guys would love having some more help.
What about sqlmanager.net - it the best GUI with number of great
I've solved this for my case in 7.4 by defining a view with the desired column
layout and the return setof the view. This certainly depends on what you're
trying to accomplish.
On Thursday 30 June 2005 09:21 am, Jason Tesser wrote:
> Can this return multiples? I thought when you dfined columns
Can this return multiples? I thought when you dfined columns dynamically like
your example it only returns one record and I need to be able to return a
set. Can your example return a set?
On Thursday 30 June 2005 10:58 am, Sven Willenberger wrote:
> If I understand the new features correctly,
On Thu, 2005-06-30 at 10:18 -0500, Jason Tesser wrote:
> HI
>
> On Thursday 30 June 2005 9:20 am, Tom Lane wrote:
> > Jason Tesser <[EMAIL PROTECTED]> writes:
> > > 1. Our dev plan involves alot of stored procedures to be used and we have
> > > found the way this is done in PG to be painful. (ie.
HI
On Thursday 30 June 2005 9:20 am, Tom Lane wrote:
> Jason Tesser <[EMAIL PROTECTED]> writes:
> > 1. Our dev plan involves alot of stored procedures to be used and we have
> > found the way this is done in PG to be painful. (ie. To return multiple
> > record from different tables you have to de
Jason Tesser <[EMAIL PROTECTED]> writes:
> 1. Our dev plan involves alot of stored procedures to be used and we have
> found the way this is done in PG to be painful. (ie. To return multiple
> record from different tables you have to define a type.
FWIW, this won't be essential any more in 8.1.
I work for a college and we use PG currently as our main backend. We are
currently developing with Java. We are considering moving away from postgres
for the reasons I am going to list below. I would appreciate some thoughts
from the Postgres community on way we should or shouldn't leave post
19 matches
Mail list logo
