[Pgsql-ayuda] nombres largos

sandrigo lezcano psql@msa.com.py
Fri, 6 Jun 2003 11:11:58 -0500


This is a multi-part message in MIME format.

------=_NextPart_000_000B_01C32C1C.722464C0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

mm... creo importante hacer estas observaciones:

creando tablas, funciones etc..
(del punto de vista de migracion):


CREATE FUNCTION "f_buscar_proceso_novedad_proceso" (smallint) RETURNS =
integer AS'
select count(numero_proceso)
  from novedades_proceso
 where numero_proceso =3D $1;'
 LANGUAGE 'sql';

/* Result : "Query OK, 0 rows affected (0.03 sec)
NOTICE:  identifier "f_buscar_proceso_novedad_proceso" will be truncated =
to "f_buscar_proceso_novedad_proces"
" */

sera solo por la version de PG..???.  ojala!!..


abrazos.




____________________________________________________
Sandrigo Lezcano Jara             Asunci=F3n, Paraguay
usando______: Ret Hat 7.2 (Enigma) - Kernel 2.4.7-10=20
              PostgreSQL 7.1.3 - psqlODBC 7.02.00.01
migrando____: Sybase 6.5   al   PostgreSQL=20
front end___: PowerBuilder 6.5        =20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DICQ:143590717=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
____________________________________________________

------=_NextPart_000_000B_01C32C1C.722464C0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>mm...&nbsp;creo importante hacer estas observaciones:</DIV>
<DIV>&nbsp;</DIV>
<DIV>creando tablas, funciones etc..</DIV>
<DIV>(del punto de vista de migracion):</DIV>
<DIV>&nbsp;</DIV>
<DIV><BR>CREATE FUNCTION "f_buscar_proceso_novedad_proceso" (smallint) =
RETURNS=20
integer AS'<BR>select count(numero_proceso)<BR>&nbsp; from=20
novedades_proceso<BR>&nbsp;where numero_proceso =3D =
$1;'<BR>&nbsp;LANGUAGE=20
'sql';</DIV>
<DIV>&nbsp;</DIV>
<DIV>/* Result : "Query OK, 0 rows affected (0.03 sec)<BR>NOTICE:&nbsp;=20
identifier "f_buscar_proceso_novedad_proceso" will be truncated to=20
"f_buscar_proceso_novedad_proces"<BR>" */<BR></DIV>
<DIV>sera solo por la version de PG..???.&nbsp; ojala!!..</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>abrazos.</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>____________________________________________________<BR>Sandrigo =
Lezcano=20
Jara&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;=20
Asunci=F3n, Paraguay<BR>usando______: Ret Hat 7.2 (Enigma) - Kernel =
2.4.7-10=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;=20
PostgreSQL 7.1.3 - psqlODBC 7.02.00.01<BR>migrando____: Sybase =
6.5&nbsp;&nbsp;=20
al&nbsp;&nbsp; PostgreSQL <BR>front end___: PowerBuilder=20
6.5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DICQ:143590717=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>_________=
___________________________________________</DIV></BODY></HTML>

------=_NextPart_000_000B_01C32C1C.722464C0--