How do I do some tracing to debug a Function... ?
I've read that to raise warnings / Exception / ... is the only mean
(beside not having any faults) & then look in Logs.
Is it so ?
Tx,
Thomas,
--
Thu Jan 4 20:19:03 CET 2001
Thomas SMETSe-mail : [EMAIL PROTECTED
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 mod
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 /etc/
"Graham Vickrage" wrote:
>I am trying to use the psql -f 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
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.
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 Postg
I am trying to use the psql -f 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 however give
> 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
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
> a
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.
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:
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 inn
> [...]
> Subqueries are covered in Bruce Momjian's book:
> http://www.postgresql.org/docs/aw_pgsql_book/node93.html
> [...]
Thanks for the information, but Bruce (which I have already read) and
all other docs I´ve seen "only" mention normal subselects. I know
subselects (what a poor database eng
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
http://www.postgresql.org/devel-corner/docs/postgres/sql-langu
14 matches
Mail list logo