On Dec 17, 2007 12:24 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "robert lazarski" <[EMAIL PROTECTED]> writes:
> > Is there any way to get the above insert to work as is, via a function
> > or some other way? I tried the function of another poster but it seems
> > there is already a cast built in fo
"robert lazarski" <[EMAIL PROTECTED]> writes:
> Is there any way to get the above insert to work as is, via a function
> or some other way? I tried the function of another poster but it seems
> there is already a cast built in for 8.1.9 for integer to boolean, and
> it didn't work for me on the abo
On Dec 14, 2007 12:49 PM, Gregory Stark <[EMAIL PROTECTED]> wrote:
>
> "robert" <[EMAIL PROTECTED]> writes:
>
> > So it has two 'bool' - "includeScenario" and "deleted" . I have an
> > insert like...
> >
> > INSERT INTO "ASSETSCENARIO"
> > ("assetScenarioID",OBJ_VERSION,"includeScenario","scenario
On Wednesday 12 December 2007 8:09 pm, robert wrote:
> Hi all, I've spent the last few days hacking a mssql INSERT script to
> work with 8.1.9 - I could build the latest postgres source if need be.
> My latest problem is:
>
> ERROR: column "includeScenario" is of type boolean but expression is
> o
"robert" <[EMAIL PROTECTED]> writes:
> So it has two 'bool' - "includeScenario" and "deleted" . I have an
> insert like...
>
> INSERT INTO "ASSETSCENARIO"
> ("assetScenarioID",OBJ_VERSION,"includeScenario","scenarioName","probability","occurenceDate","notes","priceTarget","assetID","created","mo
--- On Thu, 12/13/07, robert <[EMAIL PROTECTED]> wrote:
> > Hi all, I've spent the last few days hacking a
> mssql INSERT script to
> > work with 8.1.9 - I could build the latest postgres
> source if need be.
a standard cast() wouldn't work for you?
proj02u20411=> select cast( 1 as boolean),
pr
On Dec 12, 11:09 pm, robert <[EMAIL PROTECTED]> wrote:
> Hi all, I've spent the last few days hacking a mssql INSERT script to
> work with 8.1.9 - I could build the latest postgres source if need be.
> My latest problem is:
>
> ERROR: column "includeScenario" is of type boolean but expression is
>
