tag:blogger.com,1999:blog-8839574367290288724.post5276263111553797839..comments2023-12-11T13:13:11.330-08:00Comments on Pavel Stehule's blog: frequent mistakes in plpgsql designPavel Stěhulehttp://www.blogger.com/profile/01996484227228696817noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8839574367290288724.post-75059931524759297702010-04-21T02:51:29.765-07:002010-04-21T02:51:29.765-07:00'to short function' in our system we wrap ...'to short function' in our system we wrap all SQL requests in DB procedure. Usually even very simple 'select' afer few month can be tranformed in something more complex. My opinion is that - DB procedures should by developed by DB people , typical PHP/Java developer knows to little to create optimal DB queries.http://blog.szymanskich.nethttps://www.blogger.com/profile/01104914286930756840noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-27388968752008224642010-04-20T05:45:26.163-07:002010-04-20T05:45:26.163-07:00To Thom: Thanks for echo, fixed.To Thom: Thanks for echo, fixed.Pavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-48402690234719077892010-04-20T05:30:17.589-07:002010-04-20T05:30:17.589-07:00Actually, I can see it already deals with that wit...Actually, I can see it already deals with that with the coalesce. Ignore that last part.Thomhttps://www.blogger.com/profile/02563102260614838138noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-88535202086871352042010-04-20T05:28:07.822-07:002010-04-20T05:28:07.822-07:00That last example needs 1 or 2 corrections. The i...That last example needs 1 or 2 corrections. The input parameter "schema" needs to be "schemaname". And could you use "schemaname varchar DEFAULT 'public')"? Or if not, default with a NULL schemaname so it falls back to the schema search path?Thomhttps://www.blogger.com/profile/02563102260614838138noreply@blogger.com