Guest User

Untitled

a guest
Apr 25th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1.  
  2. # Note, this proc does not work at all if it is passed any of the
  3. # date parameters. Here is why:
  4. #
  5. # query_value := 'SELECT user_id, creation_tsz, extract (epoch from
  6. # timestamptz (creation_tsz)) FROM favorite_listings
  7. # WHERE target_user_id=' || target_user_id_input || ''
  8. # || month_option || year_option ||
  9. # 'ORDER BY creation_tsz DESC';
  10. #
  11. # Catch it? There's no space between the date options and ORDER BY.
  12. # So there's no way anybody ever tested this proc. Luckily it's a cut
  13. # and paste job from unlimited emid version, which breaks too.
  14. # /rant
Add Comment
Please, Sign In to add comment