[SQL] what is similar to like operator in mysql for postgresql

hi all, can you tell me what is similar to like operator in mysql for postgresql hatem gamal -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] pagination problem in postgresql need help

hi, please see this code select aiah_number.aiah_number_id, aiah_number.aiah_number, lock.lock_status, rank.rank_value, approve.approve_status, lock.view from aiah_number inner join lock on aiah_number.locked = lock.lock_id inner join rank on aiah_number.rank = rank.rank_id inner join approve