[SQL] SQL Spec Compliance Questions

2004-03-30 Thread Josh Berkus
Folks, Just got this do we support it questionnaire from a signficant commercial entity vaguely interested in supporting PostrgreSQL.Since I'm often foggy on the differences between the SQL99 and SQL92 spec definitions of things, I thought I'd post it for feedback here: 1) SQL-92 SELECT,

Re: [SQL] SQL Spec Compliance Questions

2004-03-30 Thread Tom Lane
Josh Berkus [EMAIL PROTECTED] writes: Just got this do we support it questionnaire from a signficant commercial entity vaguely interested in supporting PostrgreSQL. This looks more like an underling with a checklist than a serious inquiry. Can you get them to specify particular capabilities

Re: [SQL] SQL Spec Compliance Questions

2004-03-30 Thread Josh Berkus
Tom, This looks more like an underling with a checklist than a serious inquiry. Can you get them to specify particular capabilities that they need? In sufficient detail that we could actually answer? I'll ask, but I'm not sure that I can. The particular company is very bureaucratic, and

[SQL] plpgsql vs. SQL in stored procedures

2004-03-30 Thread Ivan Sergio Borgonovo
Is there a way to declare variables and use IF in plain SQL, not in plpgsql inside stored procedures? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster