On Fri, Jun 01, 2001 at 09:30:40AM -0700, Josh Berkus wrote:
>
> When I edit some of my more complex plpgsql functions using PGAccess,
> the functions break and cannot be made to work again except by reloading
> them from PLSQL/text. All attempts to use the function after PGAccess
> editin
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> When I edit some of my more complex plpgsql functions using PGAccess,
> the functions break and cannot be made to work again except by reloading
> them from PLSQL/text. All attempts to use the function after PGAccess
> editing are met with: 'Parse
Folks,
I've been having an annoying problem that I'm hoping someone else has
had and solved:
When I edit some of my more complex plpgsql functions using PGAccess,
the functions break and cannot be made to work again except by reloading
them from PLSQL/text. All attempts to use t
Jack,
> select into rec1 * from EMP where empNo ='''';
> i1 := xxx(rec1,5);
Bad syntax. The correct syntax is:
SELECT * INTO rec1 FROM EMP WHERE empNo='''';
> 2. Is that possible to return a record from a function? And how do I
> get the
> returned record in PL/pgSql
Mark,
> How does one perform date manipulation within SQL? For example, SQL
> Server has a dateadd() function that takes a date part, scalar, and
> the
> date to manipulate.
As I have remarked before, such functions as DATEADD are unnecessary in
PostgreSQL because PostgreSQL has a proper implem
--
David BOURIAUD
--
In a world without walls or fences, what use do we have
for windows or gates ?
--
ICQ#102562021
Tom Lane wrote:
You are totally right !
>
> I don't think so:
David BOURIAUD <[EMAIL PROTECTED]> writes:
> This query doesn't work, the back-end answers Error : Invalid Command
> name "0"...
I don't think so: there is no such error string anywhere in the PG
sources. (Also, when I try the query, it seems to work fine.)
However, I find the following possibl
Hi the list !
I'm new to this list.
I've tried to write a sql query to get all the fields of a table and to
have mentionned is a field can be null or not, and if a field is a key
or not.
Before showing the query I send, let me tell you that I'm running
postgre v7.1.2 on a SuSE Linux 6.4 box, and t
