I'm trying to write a stored procedure in python with postgresql 7.4,
but I cannot return a record or a setof record.
I get this error:
ERROR: cannot accept a value of type record
Is possible to return a record or am I trying to do something impossible?
Thank you
signature.asc
Description:
"ALÝ ÇELÝK" <[EMAIL PROTECTED]> writes:
> There is a new installed PostgreSQL 8.1.4 running on Windows2003.
> 2006-07-13 19:43:57.234 192.168.3.14(1093) test user SELECTERROR: could
> not access status of transaction 679109
> 2006-07-13 19:43:57.234 192.168.3.14(1093) test user SELECTDETAIL: c
Hi,
I had posted this question a few days back.
Sending the same question again.
I have a C program and have some ECPG code in it.
How do i display the data that i retrieve from the postgres database using a simple select statment or calling a stored procedure.
Is it mandatory to use cursor
Hi, suppose I have two tables
table User
{
id integer,
name text,
address text
}
Table UserWork
{
userid integer references User(id),
work text
}
Suppose I have three users
idnameaddress
1 Tony main street
2 Peter Big ave
3 Richard Loop Blvd
An
On Sat, Jul 22, 2006 at 12:47:42PM -0700, [EMAIL PROTECTED] wrote:
> I would like to join table user and userwork, where if a user has a
> work, I list it. If he does not, I give it some default value "no work"
You could use an outer join and COALESCE.
http://www.postgresql.org/docs/8.1/interacti
Thank you for your post. To make things a little bit complicated:
Suppose I have another table UserInformation
UserInfomation
{
userid integer referenes user(id),
mothername text
}
I would like methername also appear in the final join. Suppose each
user must have a mothername.
Could yo
Hi
There is NOD32 Antivirus on the system but it is not scanning PostgreSQL
folder. I have checked disk but no errors.
Regards
Ali ÃELÃK
"Tom Lane" <[EMAIL PROTECTED]>, haber iletisinde þunlarý
yazdý:[EMAIL PROTECTED]
> "ALÃ ÃELÃK" <[EMAIL PROTECTED]> writes:
>> There is a new install
ALÝ ÇELÝK wrote:
> Hi
>
> There is NOD32 Antivirus on the system but it is not scanning PostgreSQL
> folder. I have checked disk but no errors.
Uninstall it and try again. In some cases, even inactive antiviruses
(i.e. one installed but not running at all) have been reported to cause
problems.
On Sat, Jul 22, 2006 at 01:38:38PM -0700, [EMAIL PROTECTED] wrote:
> Suppose I have another table UserInformation
>
> UserInfomation
> {
> userid integer referenes user(id),
> mothername text
> }
>
> I would like methername also appear in the final join. Suppose each
> user must have a m
