Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Bugs > BUG: aliases do...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 3751 of 3928
Post > Topic >>

BUG: aliases does not work ((

by Eugen.Konkov@[EMAIL PROTECTED] May 7, 2008 at 02:09 PM

This is a multi-part message in MIME format.

------=_NextPart_000_0084_01C8B04B.F9B873F0
Content-Type: text/plain;
	charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

 SELECT
MIN(COALESCE(cmp_values(parent_td.value, parent_md.value, =
parent_cmp.value),0)) as chk_parent,
FROM some_table

having chk_parent > 0

ERROR:  column "chk_parent" does not exist at character 2342
------=_NextPart_000_0084_01C8B04B.F9B873F0
Content-Type: text/html;
	charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dkoi8-r">
<META content=3D"MSHTML 6.00.6000.16608" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN>&nbsp;SELECT<BR>MIN(COALESCE(cmp_<WBR>values(parent_td.<WBR>va=
lue,=20
parent_md.value, parent_cmp.value)<WBR>,0)) as chk_parent,<BR>FROM=20
some_table</SPAN></DIV>
<DIV><SPAN><BR>having chk_parent <WBR>&gt; 0</SPAN></DIV>
<DIV><SPAN><FONT face=3DArial size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN><FONT face=3DArial size=3D2>ERROR:&nbsp; column "chk_parent" =
does not=20
exist at character 2342</FONT></SPAN></DIV></BODY></HTML>

------=_NextPart_000_0084_01C8B04B.F9B873F0--
 




 4 Posts in Topic:
BUG: aliases does not work ((
Eugen.Konkov@[EMAIL PROTE  2008-05-07 14:09:33 
Re: BUG: aliases does not work ((
peter_e@[EMAIL PROTECTED]  2008-05-07 13:52:37 
Re: BUG: aliases does not work ((
Eugen.Konkov@[EMAIL PROTE  2008-05-07 19:15:58 
Re: BUG: aliases does not work ((
tgl@[EMAIL PROTECTED] (T  2008-05-07 12:32:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 20 4:20:13 CDT 2008.