List:General Discussion« Previous MessageNext Message »
From:hsv Date:April 30 2013 6:46pm
Subject:Re: Long integer constant problem in views
View as plain text  
>>>> 2013/04/30 17:17 +0200, Martin Koch >>>>
CREATE OR REPLACE VIEW foo AS
  SELECT *
  FROM mytable
  WHERE id = X'36a461c81cab40169791f49ad65a3728';
<<<<<<<<
Try this: _binary X'36a461c81cab40169791f49ad65a3728'

SHOW CREATE VIEW is the command for the client.

Thread
Long integer constant problem in viewsMartin Koch30 Apr
  • RE: Long integer constant problem in viewsRick James30 Apr
  • Re: Long integer constant problem in viewshsv1 May