From: | "Mic" <Mic(dot)c(at)sloten(dot)demon(dot)nl> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Datatypes in embedded SQL |
Date: | 2001-03-26 18:35:05 |
Message-ID: | 985631638.19816.0.pluto.c29fe0e4@news.demon.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hey all.
I've a question on embedded sql.
Thing is, I'm trying to declare a struct in the embedded SQL part in my C
program, but the preprocessor complains about an 'unknown data type in line
162'. Is it not possible at all in Postgres to declare a structure? I tried
writing out the DBstruct in the SQL DECLARE section, that didn't work
either.
When i don't use the struct, passing 4 variables instead, all goes well.
I Am using Postgres server 7.0.2, and the pgcl preprocessor, running under
Mandrake Linux.
Regards,
Mic
preveously defined:
typedef struct {
int line_nr,
type;
char nick[10],
line[161];
} DBstruct;
/* ------------------------------------------------------DBinsRecord--------
does : Inserts a line in the db
args :
return : error code (0 = ok)
---------------------------------------------------------------------------
*/
static int DBinsRecord (
DBstruct *Values
)
{
EXEC SQL BEGIN DECLARE SECTION;
DBstruct *pRec = Values;
EXEC SQL END DECLARE SECTION;
EXEC SQL
INSERT INTO channel
(line_nr
,nick
,type
,line)
VALUES
( :pRec->line_nr
, :pRec->nick
, :pRec->type
, :pRec->line);
return (sqlca.sqlcode);
}
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-03-26 19:26:47 | Re: pgmonitor on solaris |
Previous Message | Peter Eisentraut | 2001-03-26 17:15:13 | Re: pgmonitor on solaris |