[Pgsql-ayuda] hay nvl en postgres

Luis Arriaga Reyes Luis Arriaga Reyes" <aarriaga@ciateq.mx
Thu, 13 Feb 2003 16:47:14 -0600 (Mexico Standard Time)
Previous message: [Pgsql-ayuda] HELP: consulta interactiva Postgres-PHPLib
Next message: [Pgsql-ayuda] hay nvl en postgres
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
--------------Boundary-00=_QAR9G6G0000000000000
Content-Type: Multipart/Alternative;
  boundary="------------Boundary-00=_QAR9BHK0000000000000"


--------------Boundary-00=_QAR9BHK0000000000000
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

 =0D
 hola lista =0D
=0D
=0D
mi problema es el siguiente: =0D
=0D
estoy realizando un portal en donde se necesitan varias consultas y repor=
tes
 se esta programando en php, y tiene que ser configurable para diferentes
plataformas en la base de datos se tiene contemplado para Oracle, postgre=
sql
 sql server y mysql.=0D
=0D
la primera versi=F3n ya esta disponible para Oracle pero ahora al tratar =
de
correrla en una base de datos en postgres me marca errores ya que uso la
instrucci=F3n NVL() para los reportes=0D
=0D
mi duda es: =BFque  instrucci=F3n puedo utilizar en postgresql que sea si=
milar a
la NVL() de Oracle=0D
=0D
=0D
Gracias de antemano espero haberme dado a entender=0D
=0D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =0D
Luis Arturo Arriaga ReyesSistemas y ElectronicaCIATEQ, A.C.(Centro de
Tecnologia Avanzada)Av. del Retablo 150, Col. FovisssteQueretaro, Qro. c.=
p
76150Tel: (01442)-2-11-26-00 ext. 516email: aarriaga@ciateq.mx=20
luis1arriaga@queretaro.com =0D
icq #:  161839428=0D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--------------Boundary-00=_QAR9BHK0000000000000
Content-Type: Text/HTML;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-=
1">
<META content=3D"IncrediMail 1.0" name=3DGENERATOR>
<!--IncrdiXMLRemarkStart>
<IncrdiX-Info>
<X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID>
<X-FVER>3.0</X-FVER>
<X-CNT>;</X-CNT>
</IncrdiX-Info>
<IncrdiXMLRemarkEnd-->
</HEAD>
<BODY style=3D"BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px=
 10px 10px; FONT-FAMILY: Arial" bgColor=3D#ffffff background=3D"" scroll=3D=
yes ORGYPOS=3D"0" X-FVER=3D"3.0">
<TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D"100=
%" border=3D0>
<TBODY>
<TR>
<TD id=3DINCREDITEXTREGION style=3D"FONT-SIZE: 12pt; CURSOR: auto; FONT-F=
AMILY: Arial" width=3D"100%">
<DIV>&nbsp;</DIV>
<DIV>&nbsp;hola lista </DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>mi problema es el siguiente:&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>estoy realizando un&nbsp;portal en donde se necesitan varias consult=
as y reportes,&nbsp;se esta programando en php,&nbsp;y&nbsp;tiene que ser=
 configurable para diferentes plataformas en la base de datos se tiene co=
ntemplado para Oracle, postgresql, sql server y mysql.</DIV>
<DIV>&nbsp;</DIV>
<DIV>la primera versi=F3n ya esta disponible para Oracle pero ahora al tr=
atar de correrla en una base de datos en&nbsp;postgres me&nbsp;marca&nbsp=
;errores ya que uso la&nbsp;instrucci=F3n NVL() para&nbsp;los reportes</D=
IV>
<DIV>&nbsp;</DIV>
<DIV>mi duda es: =BFque &nbsp;instrucci=F3n puedo utilizar en postgresql =
que sea similar a la NVL() de Oracle</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>Gracias de antemano espero haberme dado a entender</DIV>
<DIV><IMG src=3D"cid:0845EE69-DE56-406F-B5A1-FE1674EB7D6F"></DIV>
<DIV><PRE><PRE><EM><STRONG>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=20
</STRONG></EM><EM><STRONG>Luis Arturo Arriaga Reyes</STRONG></EM></PRE><P=
RE><EM><STRONG>Sistemas y Electronica</STRONG></EM></PRE><PRE><EM><STRONG=
>CIATEQ, A.C.(Centro de Tecnologia Avanzada)</STRONG></EM></PRE><PRE><EM>=
<STRONG>Av. del Retablo 150, Col. Fovissste</STRONG></EM></PRE><PRE><EM><=
STRONG>Queretaro, Qro. c.p 76150</STRONG></EM></PRE><PRE><EM><STRONG>Tel:=
 (01442)-2-11-26-00 ext. 516</STRONG></EM></PRE><PRE><EM><STRONG>email: <=
A href=3D"mailto:aarriaga@ciateq.mx">aarriaga@ciateq.mx</A></STRONG></EM>=
<EM><STRONG>  <A href=3D"mailto:luis1arriaga@queretaro.com">luis1arriaga@=
queretaro.com</A>=20
</STRONG></EM><EM><STRONG>icq #:  161839428
</STRONG></EM><EM><STRONG>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D</STRONG></EM></PRE></PRE></DIV></TD></TR>
<TR>
<TD id=3DINCREDIFOOTER width=3D"100%">
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%">
<TBODY>
<TR>
<TD width=3D"100%"></TD>
<TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle></TD>
<TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle></TD></TR></TBODY></T=
ABLE></TD></TR></TBODY></TABLE><SPAN id=3DIncrediStamp><SPAN dir=3Dltr><F=
ONT face=3D"Arial, Helvetica, sans-serif" size=3D2>______________________=
___________________________________________<BR><FONT face=3D"Comic Sans M=
S" size=3D2><A href=3D"http://www.incredimail.com/redir.asp?ad_id=3D310&a=
mp;lang=3D10"><IMG alt=3D"" hspace=3D0 src=3D"cid:D065C7E8-E4D1-4965-9EAF=
-F27C6AEF7E08" align=3Dbaseline border=3D0></A>&nbsp; <I>IncrediMail</I> =
- <B>El E-mail ha evolucionado finalmente</B> - </FONT><A href=3D"http://=
www.incredimail.com/redir.asp?ad_id=3D310&amp;lang=3D10"><FONT face=3D"Ti=
mes New Roman" size=3D3><B><U>Haga clic aqu=ED</U></B></FONT></A></SPAN><=
/SPAN></FONT></BODY></HTML>
--------------Boundary-00=_QAR9BHK0000000000000--

--------------Boundary-00=_QAR9G6G0000000000000
Content-Type: image/gif;
  name="sg-0.gif"
Content-Transfer-Encoding: base64
Content-ID: <0845EE69-DE56-406F-B5A1-FE1674EB7D6F>

R0lGODlheQBAAPABAAAAAL29vSH5BAEAAAEALAAAAAB5AEAAAAL+jI+py+0Po5y02ouz3rz7D4bi
SJbmiabqyrbuC8fyTNf2jef6zvf+DwwKh8Si8YhMKpfMpvPpBEBfAOm0VUVZr4ZsKbu9ekfe8dQc
CgfUUbYHvRa7O2740k5nzBvVPQ2v54ewJ6gA+Fc4OEEomGhzqME4qBa2BelymTGH1mfV19XVuVnZ
SZboSWHHSXqA2koqNWbpmFrHOttouDrZCvqq2OsbmmY7GyfswHn8y7xsHCxslrk4+ovbWLkc+uwM
Rum6LfqBJxur+yAKvlauvh776T7NQW4M5ygNpqmnAiiO/B8DHi0M6dKFGzXwRBkdBeXxg8bFhKWI
WuBRvIgxo8YVjRw7evwIMqTIkSRLmjyJMqXKFwUAADs=

--------------Boundary-00=_QAR9G6G0000000000000
Content-Type: image/gif;
  name="IMSTP.gif"
Content-Transfer-Encoding: base64
Content-ID: <D065C7E8-E4D1-4965-9EAF-F27C6AEF7E08>

R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gL////wAAAAAAAAAAAAAAAAAAAAAA
AAAAACH/C05FVFNDQVBFMi4wAwEAAAAh+QQJFAAIACwAAAAAFAAPAAAEVRDJSaudJuudrxlEKI6B
URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt
E30tVVRscMHDqV/u+AgAIfkEBWQACAAsAAAAABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE
CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ
AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAAAAAFAAPAAAEEhDJ
Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj
1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5
BAVkAAgALAAAAAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs=

--------------Boundary-00=_QAR9G6G0000000000000--
Previous message: [Pgsql-ayuda] HELP: consulta interactiva Postgres-PHPLib
Next message: [Pgsql-ayuda] hay nvl en postgres
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]