Hi guys,
Thanks for the input so far. No it wasn't a direct paste, what I did in fact
type was SELECT sp_insert_manifest('me', '[EMAIL PROTECTED]', '[EMAIL
PROTECTED]',
'test.txt', NULL, '2006/06/09'). The error message said something like
function sp_insert_manifest(character varying, character
You will have to use the "CALLED ON NULL INPUT" option to "create function"
(Postgresql 8.1, I don't know about other
versions) if you expect NULL arguments.
Jim
-- Original Message ---
From: "Rommel the iCeMAn" <[EMAIL PROTECTED]>
To: "PostgreSQL SQL Mailing List"
Sent: Fri,
- Original Message -
From: "Rommel the iCeMAn" <[EMAIL PROTECTED]>
I am trying to pass the following values to the function but I have been
so
far unsuccessful.
What error message are you receiving?
SELECT sp_insert_manifest('me', [EMAIL PROTECTED]', '[EMAIL PROTECTED]', 'test.t
Hi list,
I'm a newbie and I have a problem. I've defined the following function using
pgAdmin but I am clueless as to how I can test it. I will eventually be
calling this function from a .NET application but I want to test it using
raw SQL first. Here's the function definition:
CREATE OR REPLAC
"select 1 where false" does indeed indicate an empty set. I was hoping for
something more elegant, but I'll take what I can get. :)
--- Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Thu, Jun 08, 2006 at 14:40:12 -0700,
> CG <[EMAIL PROTECTED]> wrote:
> > PostgreSQL 8.1
> >
> > I've been try
On Thu, Jun 08, 2006 at 14:40:12 -0700,
CG <[EMAIL PROTECTED]> wrote:
> PostgreSQL 8.1
>
> I've been trying to write a SQL prepare routine. One of the challenging
> elements I'm running into is an empty set ...
>
> "select foo from bar where foo in ? ;"
>
> What if "?" is an set with zero elem
