Hello,<br /><br />Does anyone know how to make a Select that even having a Char(1) with the letter C the statement
makesthe rows appearing 'CREDIT' ?<br /><br />Like: <br /> On table:<br /><br />When Type<br />2007-01-01 C
<br/>2007-01-02 C<br />2007-01-03 C<br /><br />On SQL result<br />When Type<br /> 2007-01-01 CREDIT<br
/>2007-01-02 CREDIT<br /> 2007-01-03 CREDIT<br /><br />Thanks in advande,<br /><br clear="all" /><br />-- <br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=<br/> Atenciosamente
(Sincerely)<br/> Ezequias Rodrigues da Rocha<br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é melhor do
quea melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships<br /><a
href="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>
From:
Michael Glaesemann Date: Subject:
Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql?
