Hey Roman,
Thanks for your reponse's!
I made it happen in MicrosoftSQL using the first code below. The only
difference is I had to create variables. Which I'm having a hard time
trying to replicate it in psql.
__Microsoft Code___
USE test
GO
DECLARE @qty INT, @Length varchar(20
Thanks Roman for sticking with me on this!
For whatever reason I cannot load another langage, I think it has to do
with recompiling the program and installing all the options. Not sure
though?? LANGUAGE plpgsql doesn't exist for me.
I still find this cursor limitation wacked. I find it hard to
I found using the shell works but using the phAdminIII GUI is the one
that gives me problems. I've even tried running it on EMS PostgreSQL
Manager 3. Same results. Is this normal?
Got a couple more questions regarding cursors.
1. When I try to run this statement (Declare curs1 refcursor;) I ge
I did a couple of tests and found that occationally when using the
wizard it added "" to my names. When this happens it forces the whole
table to be case sensitive. Anyway I think I'll just stick to manually
creating my tables.
---(end of broadcast)--
Trying out PostgreSQL for the first time and running into a minor
problem.
I created two tables one with the Add table wizard the other hard-core
script.
Script made table:
Select * from Example
--This works as expected
Select * from EXAMPLE
--This works as expected
Wizard made table:
Select * fr
Here is a further test:
--
BEGIN WORK;
DECLARE cursor1 CURSOR FOR SELECT * FROM PARTS;
FETCH FIRST IN cursor1;
INSERT INTO partstemp VALUES (PARTS.QTY, PARTS.LENGTH, PARTS.WIDTH);
CLOSE cursor1;
COMMIT WORK;
--
BEGIN WORK;
DECLARE cursor1 CURSOR FOR SELECT * FROM PARTS;
FETCH FIRST FROM cursor1;
CLOSE cursor1;
COMMIT WORK;
Query result with 1 rows discarded.
Query returned successfully with no result in 31 ms.
In the "data output" view nothing is returned?
