'Plpgsql' web sites
Select from depesz; blog archive how i learned to stop worrying and love [..]
www.depesz.com 2012-11-20 ⚑blog
plpgsql ; In case you 8217;re not familiar with functions in PostgreSQL line 1 8211; begins 8220;CREATE FUNCTION 8221; statement, including information that the function will be named normalize fullname, will not have any arguments 8220; 8221;, and it returns value of pseudotype trigger. line 2 8211; every function in plpgsql check line 6 has to have BEGIN. END; block, which is its body line 3 8211; NEW is record which contains
www.depesz.com 2012-11-20 ⚑blog
plpgsql ; In case you 8217;re not familiar with functions in PostgreSQL line 1 8211; begins 8220;CREATE FUNCTION 8221; statement, including information that the function will be named normalize fullname, will not have any arguments 8220; 8221;, and it returns value of pseudotype trigger. line 2 8211; every function in plpgsql check line 6 has to have BEGIN. END; block, which is its body line 3 8211; NEW is record which contains
MORE
ⓘ
Select from depesz; aggregate
plpgsql , postgresql, rhodiumtoad, sql. 1 comment Today, on irc postgresql on freenode.net Dim mentioned about writing median calculation code. It got me thinking, and consequently writing my version of median calculation code. Waiting for 8.4 8211; window functions January 21st, 2009 by depesz. Tags aggregate, avg, cumulative sum, groups, partitions, pg84, postgresql, rownum, sum, window functions. 2 comments A long overdue post
MORE
ⓘ
Select from depesz; blog archive how to manage changes to your database.
plpgsql , postgresql, versioning. 27 comments Did it help. If yes. maybe you can help me. Donate BTC to 19zPa5diT2LZqGtTi8f8bfApLn8rw9zBHx Every now and then somebody asks how to make diff of database schemata. Usual background is like we have production database, and development database, and we want to see what is different on development to be able to change production in the same way. Personally I think that such approach is
Expertise postgresql. 2ndquadrant france
tapoueh.org 2012-03-16 ⚑enterprise
plpgsql catalogs PostgreSQLfr mailq rcirc ip4r postfix preprepare FOSDEM pgsql.linum.format PGQ pgextwlist Lisp monitoring munin pgbouncer pgfouine Backups plproxy Archiving Replication WalMgr pgfincore Tsung tricks modeline emacs.kicker backports Projects You can browse some projects I ve released, you ll find PostgreSQL prefix, pgloader, preprepare, pg staging and more ; and Emacs el.get, ClusterSSH, mailq and more. Unless
tapoueh.org 2012-03-16 ⚑enterprise
plpgsql catalogs PostgreSQLfr mailq rcirc ip4r postfix preprepare FOSDEM pgsql.linum.format PGQ pgextwlist Lisp monitoring munin pgbouncer pgfouine Backups plproxy Archiving Replication WalMgr pgfincore Tsung tricks modeline emacs.kicker backports Projects You can browse some projects I ve released, you ll find PostgreSQL prefix, pgloader, preprepare, pg staging and more ; and Emacs el.get, ClusterSSH, mailq and more. Unless
Postgresql. page 3
postgresql.1045698.n5.nabble.com 2013-03-18
plpgsql parsing bug by rikard diams; diams; 2 by rikard PostgreSQL. bugs bug in 9.2.2. subquery accepts wrong column name upd by Achilleas Mantzios diams; diams; 2 by Achilleas Mantzios PostgreSQL. sql A new JDBC driver.. by Kevin Wooten diams; diams; 30 by Kevin Wooten PostgreSQL. jdbc Identity projection by Kyotaro HORIGUCHI.2 diams; diams; 30 by amitkapila PostgreSQL. hackers BUG 7942 Timestamp 19991231 240000 should not be out
postgresql.1045698.n5.nabble.com 2013-03-18
plpgsql parsing bug by rikard diams; diams; 2 by rikard PostgreSQL. bugs bug in 9.2.2. subquery accepts wrong column name upd by Achilleas Mantzios diams; diams; 2 by Achilleas Mantzios PostgreSQL. sql A new JDBC driver.. by Kevin Wooten diams; diams; 30 by Kevin Wooten PostgreSQL. jdbc Identity projection by Kyotaro HORIGUCHI.2 diams; diams; 30 by amitkapila PostgreSQL. hackers BUG 7942 Timestamp 19991231 240000 should not be out
Pl sql translation tool
postgresmigrations.com 2014-11-15 ⚑tech
plpgsql Translation Tool version 2.1 We are excited to announce the release of version 2.1 of our Oracle PL SQL to Postgres plpgsql translation tool. This release includes the following extensions DML trigger support added. Transaction Support COMMIT ROLLBACK included. DECODE to CASE translation added. MERGE translation added. CONNECT BY translation enhanced. Dynamic SQL enhancements. Date and Timestamp math enhancements.
postgresmigrations.com 2014-11-15 ⚑tech
plpgsql Translation Tool version 2.1 We are excited to announce the release of version 2.1 of our Oracle PL SQL to Postgres plpgsql translation tool. This release includes the following extensions DML trigger support added. Transaction Support COMMIT ROLLBACK included. DECODE to CASE translation added. MERGE translation added. CONNECT BY translation enhanced. Dynamic SQL enhancements. Date and Timestamp math enhancements.
Event triggers. postgresql wiki
wiki.postgresql.org 2015-05-07 ⚑enterprise
plpgsql Adjust many backend functions to return OID rather than void. http git.postgresql.org gitweb.p postgresql.git;a commit;h c504513f83a9ee8dce4a719746ca73102cae9f13 http git.postgresql.org gitweb.p postgresql.git;a commit;h 82b1b213cad3a69cf5f3dfaa81687c14366960fc that a preparing step so that we can expose the object OID in the event trigger not yet exposed though Add ddl command end support for event triggers. http
wiki.postgresql.org 2015-05-07 ⚑enterprise
plpgsql Adjust many backend functions to return OID rather than void. http git.postgresql.org gitweb.p postgresql.git;a commit;h c504513f83a9ee8dce4a719746ca73102cae9f13 http git.postgresql.org gitweb.p postgresql.git;a commit;h 82b1b213cad3a69cf5f3dfaa81687c14366960fc that a preparing step so that we can expose the object OID in the event trigger not yet exposed though Add ddl command end support for event triggers. http
MORE
ⓘ
Planet postgresql
plpgsql , who knows , cash words function may be found in the src backend utils adt cash.c file. It uses num word private routine. Filed under Coding, PostgresDAC Tagged PostgresDAC, PostgreSQL, trick New in PostgreSQL 9.2 format Posted by David Wheeler in pgExperts on 2012.11.16 at 01 31 00 There s a new feature in PostgreSQL 9.2 that I don t recall seeing blogged about elsewhere the format function. From the docs Read More
Pgtap unit testing for postgresql
pgtap.org 2014-11-15 ⚑tech
plpgsql AS BEGIN RETURN NEXT has table domains ; RETURN NEXT has table tuff ; RETURN NEXT has table ources ; RETURN NEXT has table domain stuff ; END; ; Once you ve created your test functions and installed them in your database, you can run them at any time using the runtests function SELECT FROM runtests mytest name ; And that s it. The runtests function will handle all the particulars, including rolling back any changes made to
pgtap.org 2014-11-15 ⚑tech
plpgsql AS BEGIN RETURN NEXT has table domains ; RETURN NEXT has table tuff ; RETURN NEXT has table ources ; RETURN NEXT has table domain stuff ; END; ; Once you ve created your test functions and installed them in your database, you can run them at any time using the runtests function SELECT FROM runtests mytest name ; And that s it. The runtests function will handle all the particulars, including rolling back any changes made to
Trent richardson. practical web development
trentrichardson.com 2012-02-07
plpgsql ; Read the rest of this entry 1 CommentUberUploadCropper V2 8211; Upload, Crop, No Flash 20 DecPosted by trent in Design, Impromptu, JavascriptFinally, UberUploadCropper gets a much needed update. First off, flash is gone. Now you can upload and crop with just javascript and your serverside language of choice. What is UberUploadCropper. It is a jQuery plugin which pulls together jCrop, Impromptu, and FileUploader plugins
trentrichardson.com 2012-02-07
plpgsql ; Read the rest of this entry 1 CommentUberUploadCropper V2 8211; Upload, Crop, No Flash 20 DecPosted by trent in Design, Impromptu, JavascriptFinally, UberUploadCropper gets a much needed update. First off, flash is gone. Now you can upload and crop with just javascript and your serverside language of choice. What is UberUploadCropper. It is a jQuery plugin which pulls together jCrop, Impromptu, and FileUploader plugins
Pgxn meta spec postgresql extension network
pgxn.org 2014-11-15 ⚑tech
plpgsql 0, PostgreSQL 8.0.0 , recommends PostgreSQL 8.4.0 , provides pgtap file sql pgtap.sql , docfile doc pgtap.mmd , version 0.2.4 , abstract Unit testing assertions for PostgreSQL , schematap file sql schematap.sql , docfile doc schematap.mmd , version 0.2.4 , abstract Schema testing assertions for PostgreSQL , resources homepage http pgtap.org , bugtracker web http github.com theory pgtap issues , repository url https
pgxn.org 2014-11-15 ⚑tech
plpgsql 0, PostgreSQL 8.0.0 , recommends PostgreSQL 8.4.0 , provides pgtap file sql pgtap.sql , docfile doc pgtap.mmd , version 0.2.4 , abstract Unit testing assertions for PostgreSQL , schematap file sql schematap.sql , docfile doc schematap.mmd , version 0.2.4 , abstract Schema testing assertions for PostgreSQL , resources homepage http pgtap.org , bugtracker web http github.com theory pgtap issues , repository url https
Andrew postgresql blog
people.planetpostgresql.org 2013-02-08 ⚑blog
plpgsql as begin return x.y text; end; ; CREATE FUNCTION andrew select v1 a ,1,2,3 ; v1. a 1,2,3 1 row andrew select v1 a ; ERROR function v1 unknown does not exist LINE 1 select v1 a ; HINT No function matches the given name and argument types. You might need to add explicit type casts. Fortunately, Postgres also allows you to supply the variadic parameter explicitly as an array, so we can achieve the wanted effect via
people.planetpostgresql.org 2013-02-08 ⚑blog
plpgsql as begin return x.y text; end; ; CREATE FUNCTION andrew select v1 a ,1,2,3 ; v1. a 1,2,3 1 row andrew select v1 a ; ERROR function v1 unknown does not exist LINE 1 select v1 a ; HINT No function matches the given name and argument types. You might need to add explicit type casts. Fortunately, Postgres also allows you to supply the variadic parameter explicitly as an array, so we can achieve the wanted effect via
MORE
ⓘ
Entries by andrew dunstan. andrew postgresql blog
plpgsql as begin return x.y text; end; ; CREATE FUNCTION andrew select v1 a ,1,2,3 ; v1. a 1,2,3 1 row andrew select v1 a ; ERROR function v1 unknown does not exist LINE 1 select v1 a ; HINT No function matches the given name and argument types. You might need to add explicit type casts. Fortunately, Postgres also allows you to supply the variadic parameter explicitly as an array, so we can achieve the wanted effect via
MORE
ⓘ
Postgresql. andrew postgresql blog
plpgsql as begin return x.y text; end; ; CREATE FUNCTION andrew select v1 a ,1,2,3 ; v1. a 1,2,3 1 row andrew select v1 a ; ERROR function v1 unknown does not exist LINE 1 select v1 a ; HINT No function matches the given name and argument types. You might need to add explicit type casts. Fortunately, Postgres also allows you to supply the variadic parameter explicitly as an array, so we can achieve the wanted effect via
Elite frontier humanity friendly information technology
elitefrontier.com 2012-02-06 ⚑tech
plpgsql template1 Posted by rdegraci Filed in 0 comments jRuby 1.6.0 and Updating Rubygems March 30th, 2011 To upgrade from Rubygems v1.5.1 that comes with jRuby 1.6.0 simply do the following gem install rubygems.update.v 1.5.2 update rubygems Once you are on Rubygems 1.5.2 then you can update using gem update.system.v 1.x.x If you need to downgrade gem install rubygems.update.v 1.5.1 gem uninstall rubygems.update.v 1.5.2 update
elitefrontier.com 2012-02-06 ⚑tech
plpgsql template1 Posted by rdegraci Filed in 0 comments jRuby 1.6.0 and Updating Rubygems March 30th, 2011 To upgrade from Rubygems v1.5.1 that comes with jRuby 1.6.0 simply do the following gem install rubygems.update.v 1.5.2 update rubygems Once you are on Rubygems 1.5.2 then you can update using gem update.system.v 1.x.x If you need to downgrade gem install rubygems.update.v 1.5.1 gem uninstall rubygems.update.v 1.5.2 update
Select from depesz; blog archive how i learned to stop worrying and love [..]
www.depesz.com 2012-11-20 ⚑blog
plpgsql ; In case you 8217;re not familiar with functions in PostgreSQL line 1 8211; begins 8220;CREATE FUNCTION 8221; statement, including information that the function will be named normalize fullname, will not have any arguments 8220; 8221;, and it returns value of pseudotype trigger. line 2 8211; every function in plpgsql check line 6 has to have BEGIN. END; block, which is its body line 3 8211; NEW is record which contains
www.depesz.com 2012-11-20 ⚑blog
plpgsql ; In case you 8217;re not familiar with functions in PostgreSQL line 1 8211; begins 8220;CREATE FUNCTION 8221; statement, including information that the function will be named normalize fullname, will not have any arguments 8220; 8221;, and it returns value of pseudotype trigger. line 2 8211; every function in plpgsql check line 6 has to have BEGIN. END; block, which is its body line 3 8211; NEW is record which contains
MORE
ⓘ
Select from depesz; aggregate
plpgsql , postgresql, rhodiumtoad, sql. 1 comment Today, on irc postgresql on freenode.net Dim mentioned about writing median calculation code. It got me thinking, and consequently writing my version of median calculation code. Waiting for 8.4 8211; window functions January 21st, 2009 by depesz. Tags aggregate, avg, cumulative sum, groups, partitions, pg84, postgresql, rownum, sum, window functions. 2 comments A long overdue post
MORE
ⓘ
Select from depesz; blog archive how to manage changes to your database.
plpgsql , postgresql, versioning. 27 comments Did it help. If yes. maybe you can help me. Donate BTC to 19zPa5diT2LZqGtTi8f8bfApLn8rw9zBHx Every now and then somebody asks how to make diff of database schemata. Usual background is like we have production database, and development database, and we want to see what is different on development to be able to change production in the same way. Personally I think that such approach is
MORE
ⓘ
Planet postgresql
plpgsql , who knows , cash words function may be found in the src backend utils adt cash.c file. It uses num word private routine. Filed under Coding, PostgresDAC Tagged PostgresDAC, PostgreSQL, trick New in PostgreSQL 9.2 format Posted by David Wheeler in pgExperts on 2012.11.16 at 01 31 00 There s a new feature in PostgreSQL 9.2 that I don t recall seeing blogged about elsewhere the format function. From the docs Read More
Andrew postgresql blog
people.planetpostgresql.org 2013-02-08 ⚑blog
plpgsql as begin return x.y text; end; ; CREATE FUNCTION andrew select v1 a ,1,2,3 ; v1. a 1,2,3 1 row andrew select v1 a ; ERROR function v1 unknown does not exist LINE 1 select v1 a ; HINT No function matches the given name and argument types. You might need to add explicit type casts. Fortunately, Postgres also allows you to supply the variadic parameter explicitly as an array, so we can achieve the wanted effect via
people.planetpostgresql.org 2013-02-08 ⚑blog
plpgsql as begin return x.y text; end; ; CREATE FUNCTION andrew select v1 a ,1,2,3 ; v1. a 1,2,3 1 row andrew select v1 a ; ERROR function v1 unknown does not exist LINE 1 select v1 a ; HINT No function matches the given name and argument types. You might need to add explicit type casts. Fortunately, Postgres also allows you to supply the variadic parameter explicitly as an array, so we can achieve the wanted effect via
MORE
ⓘ
Entries by andrew dunstan. andrew postgresql blog
plpgsql as begin return x.y text; end; ; CREATE FUNCTION andrew select v1 a ,1,2,3 ; v1. a 1,2,3 1 row andrew select v1 a ; ERROR function v1 unknown does not exist LINE 1 select v1 a ; HINT No function matches the given name and argument types. You might need to add explicit type casts. Fortunately, Postgres also allows you to supply the variadic parameter explicitly as an array, so we can achieve the wanted effect via
MORE
ⓘ
Postgresql. andrew postgresql blog
plpgsql as begin return x.y text; end; ; CREATE FUNCTION andrew select v1 a ,1,2,3 ; v1. a 1,2,3 1 row andrew select v1 a ; ERROR function v1 unknown does not exist LINE 1 select v1 a ; HINT No function matches the given name and argument types. You might need to add explicit type casts. Fortunately, Postgres also allows you to supply the variadic parameter explicitly as an array, so we can achieve the wanted effect via
Expertise postgresql. 2ndquadrant france
tapoueh.org 2012-03-16 ⚑enterprise
plpgsql catalogs PostgreSQLfr mailq rcirc ip4r postfix preprepare FOSDEM pgsql.linum.format PGQ pgextwlist Lisp monitoring munin pgbouncer pgfouine Backups plproxy Archiving Replication WalMgr pgfincore Tsung tricks modeline emacs.kicker backports Projects You can browse some projects I ve released, you ll find PostgreSQL prefix, pgloader, preprepare, pg staging and more ; and Emacs el.get, ClusterSSH, mailq and more. Unless
tapoueh.org 2012-03-16 ⚑enterprise
plpgsql catalogs PostgreSQLfr mailq rcirc ip4r postfix preprepare FOSDEM pgsql.linum.format PGQ pgextwlist Lisp monitoring munin pgbouncer pgfouine Backups plproxy Archiving Replication WalMgr pgfincore Tsung tricks modeline emacs.kicker backports Projects You can browse some projects I ve released, you ll find PostgreSQL prefix, pgloader, preprepare, pg staging and more ; and Emacs el.get, ClusterSSH, mailq and more. Unless
Event triggers. postgresql wiki
wiki.postgresql.org 2015-05-07 ⚑enterprise
plpgsql Adjust many backend functions to return OID rather than void. http git.postgresql.org gitweb.p postgresql.git;a commit;h c504513f83a9ee8dce4a719746ca73102cae9f13 http git.postgresql.org gitweb.p postgresql.git;a commit;h 82b1b213cad3a69cf5f3dfaa81687c14366960fc that a preparing step so that we can expose the object OID in the event trigger not yet exposed though Add ddl command end support for event triggers. http
wiki.postgresql.org 2015-05-07 ⚑enterprise
plpgsql Adjust many backend functions to return OID rather than void. http git.postgresql.org gitweb.p postgresql.git;a commit;h c504513f83a9ee8dce4a719746ca73102cae9f13 http git.postgresql.org gitweb.p postgresql.git;a commit;h 82b1b213cad3a69cf5f3dfaa81687c14366960fc that a preparing step so that we can expose the object OID in the event trigger not yet exposed though Add ddl command end support for event triggers. http
'Plpgsql' white pages
- theory
pgxn.org - tglsss.pgh
- gitosismyserver.com
Sound like 'plpgsql'
No cookies are saved on your client
We are completely no-profit and volunteers
Use robots.txt to block indexing
Contact us via email for other removals
Read DMCA Policy
CopyLeft by GiPOCO 2006-2023
Contact us to contribute
info (at) gipoco.com
All trade marks, contents, etc
belong to their respective owners