tag:blogger.com,1999:blog-5541296000399974369.post4947639352484033328..comments2024-03-09T02:51:27.612-05:00Comments on Peter Eisentraut's Blog: Missing Features for PostgreSQL SQL ConformanceAnonymoushttp://www.blogger.com/profile/02849480732923051923noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-5541296000399974369.post-66193059252820335782010-03-22T12:10:24.687-04:002010-03-22T12:10:24.687-04:00Consider this a second vote for F312 MERGE. It isn...Consider this a second vote for F312 MERGE. It isn't necessary every day but there are many cases where it would be very handy, and it would make migration from MySQL substantially easier.Daniel Lyonshttp://www.storytotell.orgnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-58331043171314797992010-01-11T07:17:19.961-05:002010-01-11T07:17:19.961-05:00You missed the uppercase/lowercase identifier disc...You missed the uppercase/lowercase identifier discrepency:<br /><br />SQL: select x -> select "X"<br />PostgreSQL: select x -> select "x"Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-27375427353263562352010-01-07T06:15:44.516-05:002010-01-07T06:15:44.516-05:00In light of the optional features, stored procedur...In light of the optional features, stored procedures should be a distinct type than simply void functions; one must disallow pairing a CREATE PROCEDURE with a DROP FUNCTION. Otherwise implementing the optional features will break compatibility.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-53609423879153243152010-01-04T09:21:05.162-05:002010-01-04T09:21:05.162-05:00I think that F312 MERGE statement would be a great...I think that F312 MERGE statement would be a great improvement., worth mentioning in your list.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-19161242241882762162010-01-04T04:16:36.743-05:002010-01-04T04:16:36.743-05:00I cannot speak it exactly. My knowledge is based J...I cannot speak it exactly. My knowledge is based Jim Melton book http://www.amazon.co.uk/Understanding-SQLs-Persistent-Stored-Modules/dp/1558604618 . But is possible so some higher levels are not defined in base, it is defined in SQL/PSM.Pavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-44205585534956466382010-01-04T03:57:57.138-05:002010-01-04T03:57:57.138-05:00That might be your wish, but that is not what thos...That might be your wish, but that is not what those specific features in the SQL standard say. There are additional optional features that specify some of what you are saying.Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-86901557973004293312010-01-04T02:10:55.411-05:002010-01-04T02:10:55.411-05:00Hello, stored procedures are not only about implem...Hello, stored procedures are not only about implementation CALL statement. Stored procedures have to support passing parameters by ref. More, have to have transaction control, and optionally support of unbounded selects.Pavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.com