Tod McQuillin [EMAIL PROTECTED] writes:
I don't think the PostgreSQL User's Manual mentions sub-selects.
I think you are right :-(. Geez, that's a pretty big hole in the
docs coverage.
There is some stuff in the Tutorial --- see
Jens Hartwig [EMAIL PROTECTED] writes:
I have never seen a statement like
SELECT a, (SELECT b)
FROM xyz;
IMHO this is no normal subselect and it does not correlate with the
SQL-standard. Is it a trick?
I think it's OK (we're assuming that a and b are columns of xyz, right?)
The inner
Hello Tom,
[...]
SELECT a, (SELECT b)
FROM xyz;
[...]
I think it's OK (we're assuming that a and b are columns of xyz, right?)
[...]
immediately after having sent my message I realized my fault: a and b
are not of the same table! Correctly, the statement had to be something
like:
On Tue, 2 Jan 2001, Albert REINER wrote:
Saluton,
does anyone know whether there is any support at all for arrays
in PL/pgSQL?
Yes, but it is not suggested for use. See
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz/Linux/PostgreSQL/strukturak/examples.tar.gz,
function csoporttag_e.
On Thu, 4 Jan 2001, Jens Hartwig wrote:
This would be a self-join of one table like:
select ord.a_nr,
c1.count(*),
c2.count(*),
...
from orders ord,
cylinders c1,
cylinders c2,
...
where c1.z_a_nr = ord.a_nr
and
Saluton,
does anyone know whether there is any support at all for arrays
in PL/pgSQL?
A second comment: as far as I know, no support for built-in array
variables at all. I usually create temporary tables for doing jobs I need
arrays.
Zoltan
I am trying to use the psql -f filename option to load a script into the
DB ( v7.0 ) from the linux command line.
The documentation says -f enables some nice features such as error messages
with line numbers. It seems to me that this is half true i.e. it shows me
error messages, its doesn't
Mr. Vanags,
Please be aware that you e-mailed a PostgreSQL developer mailing list.
If you were looking for courses on Microsoft SQL Server, this is an
inappropriate forum for such requests. You might, however, try
www.infotech.com for Microsoft training.
IF you need formal instruction in
Julio,
The best I've seen is a web interface -- phpPgAdmin. I think it's from
phpwizards or it's a project on sourceforge -- search google for it and
you'll have yourself a link. It allows gui control for most common tasks,
and you can submit raw sql from it too for more exotic tasks.
"Graham Vickrage" wrote:
I am trying to use the psql -f filename option to load a script into the
DB ( v7.0 ) from the linux command line.
The documentation says -f enables some nice features such as error messages
with line numbers. It seems to me that this is half true i.e. it shows
Graham Vickrage writes:
The documentation says -f enables some nice features such as error messages
with line numbers. It seems to me that this is half true i.e. it shows me
error messages, its doesn't however give me the associated line number in
the script.
Works here:
$ psql -f
Hi,
In pgsql
I'm removing charaters from a String which should be numbers.
I then want to make calculations on these numbers (calculate the ISBN
number).
Do I have to cast the char into int's before I can do the calulations.
Also I looked in the User manual but could not find the
12 matches
Mail list logo