Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Note, this proc does not work at all if it is passed any of the
- # date parameters. Here is why:
- #
- # query_value := 'SELECT user_id, creation_tsz, extract (epoch from
- # timestamptz (creation_tsz)) FROM favorite_listings
- # WHERE target_user_id=' || target_user_id_input || ''
- # || month_option || year_option ||
- # 'ORDER BY creation_tsz DESC';
- #
- # Catch it? There's no space between the date options and ORDER BY.
- # So there's no way anybody ever tested this proc. Luckily it's a cut
- # and paste job from unlimited emid version, which breaks too.
- # /rant
Add Comment
Please, Sign In to add comment